THE TOP 10 MISTAKES MADE BY SQL SERVER DBAS The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. … [Read more...]
Archives for August 2015
DBTA – The Top 10 Mistakes Made by SQL Server DBAs
August 10, 2015 by Leave a Comment
The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. What are the Top 10 Mistakes of SQL Server … [Read more...]
SQL Sentry Grows in the UK and Beyond
August 7, 2015 by Leave a Comment
The following is an excerpt from Kevin's full blog post at the SQL Sentry team blog. Read the full post HERE. ... It's with great pleasure that I announce we are hiring TWO new sales engineers to start on Monday, August 10th: John Martin (@sqlservermonkey) and Richard Douglas (@sqlrich). (See Richard's post HERE). John and Richard come to us with impeccable credentials, outstanding technology skills, a long history of community activism and unimpeachable ethics. These gentlemen are among the best of the best. Their list of achievements and accolades are long (click on their … [Read more...]
Professional Development – A Recipe for Success
August 6, 2015 by Leave a Comment
Originally appearing at ForITPros.com. Joe Webb's father-in-law spent most of his adult life as a cardiologist. That's a highly specialized and highly technical area in the field of medicine that deals with the heart. Not every physician can claim to be a cardiologist. It requires rigorous training under the close supervision of an existing cardiologist. That period of training and supervision is called a fellowship. Likewise, many building trades such as electricians, plumbers, and machinists undergo a period of training from someone with more experience. The Apprentice becomes a … [Read more...]
DBTA – StretchDB, a Cool New Feature in vNext SQL Server
August 5, 2015 by Leave a Comment
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of various database platforms such as MySQL and Hadoop, but also supporting premier commercial DBMSs such as Microsoft SQL Server and Oracle. Meanwhile, Microsoft has, in my mind, carved out a very strong niche as the innovation … [Read more...]
Buy Generic Cialis
August 4, 2015 by Leave a Comment
Buy Cialis Online Vidalista – a highly effective and powerful sex driver for men! Are you experiencing problems with potency? Have you ever misfired in bed? Vidalista is a great solution to all your erectile problems from India. One tablet of this wonderful drug will forever change your sex life, and it will once again sparkle with new emotions. Why should I choose Vidalista? Do you want to experience incredible sexual pleasures and go on new sexual adventures? Buy Vidalista online and taste all the benefits of this popular Indian ED medication. Among other things, you’ll … [Read more...]
Predicate Logic, Four Things I Wish I’d Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance
August 4, 2015 by Leave a Comment
Some of my favorite articles originally appearing at SQLPerformance.com. Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com! Four Things I Wish I Knew Sooner as a SQL Server DBA Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database … [Read more...]
ICYMI – Predicate Logic, Four Things I Wish I’d Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance
August 4, 2015 by Leave a Comment
A digest of great articles originally appearing at SQLPerformance.com. Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com! Four Things I Wish I Knew Sooner as a SQL Server DBA Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database … [Read more...]
