Tinker, Tailor, Developer, DBA is not intended as a pitch on a slightly less harrowing book or movie than the John Le Carre classic. ...
Tinker, Tailor, Developer, DBA
read more
blog
Backup and Restore of Windows Azure SQL Databases
A growing number of companies have already moved some level of applications and data to the cloud. An equally growing number of companies are still...
Your new job as a DBA
Are you a database administrator who just started a new job? Have you just taken administrator responsibilities for a new business unit’s databases?...
Becoming a Top DBA – Learning Automation in SQL Server
Joseph D'Antoni, Microsoft MVP provides insight and examples from his experience as a consultant. The value you truly bring to your...
Agent vs. Agentless Monitoring
With a unified IT monitoring solution like up.time one of the more popular discusses we have with users is agent versus agentless monitoring. In...
Service Broker Gone Wild: Dealing With sysxmitqueue Bloat
Have you ever been surprised by suddenly finding out that one of your databases has grown way beyond your expectations? Hopefully, this isn’t...
New SQL Suites available now!
Today Idera announces a set of three exciting new bundles in addition to its existing popular SQL Management Suite (formerly called SQL Suite)....
Team DBA and Collaboration
In previous blog posts I have explored the relevance of the DBA position itself in business and the unique ways that SQL Server DBAs tend to...
Converting A List of Identifiers into SQL Statements
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull a result set for them I would be a very wealthy man....
Integrating Data from Multiple Sources: Making Sense of Conformable Data – by David Loshin, Knowledge Integrity
This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about...
Resurrection of SQL with Big Data and Hadoop
Did you really think that SQL was going away? Attend this session to learn how SQL is a vital part of the next generation of data environments. Find...
The Top Productivity Solution for DBAs
Why has Monster Energy drink become standard operating equipment for DBAs? Join us for a hard-hitting look at the state-of-the-union for DBAs, what...
Managing Database Security and Compliance
When managing database security and compliance, the DBA can't take a chance on anything falling through the cracks. In this session, you'll...
What You Know but Don't Know
How To Know What You Don’t Know - Path to the DBA World As a new DBA to a company it can be overwhelming and sometimes confusing on knowing where to...
Congratulations You're a DBA…Now What?!
This is a guest article by SQL Server MVP Mike Walsh (www.straightpathsql.com | www.linchpinpeople.com), based on an Embarcadero sponsored webinar...
Solving Performance Problems on Oracle DB
DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are...
Bind Variables and Application Performance
Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL...
Achieving Database Schema Compliance at a UK Finance Institute
The requirement to maintain and prove schema compliance within the organization's database inventory continues to expand. The key objective is...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio
A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are...
Top 3 Development Environments for PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any...
Knowing Your Storage Basics – 2 Life Lessons
In the software world, it is often the case where everyone wants to learn and master everything. The problem with this approach is that we land into...
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
Proof of Concepts made Easy with The Cloud
As a Solutions Architect, there are times when you actually need to replicate customer scenarios, often becomes a challenge, unless you have your...