How to: Configure SQL Server 2012 AlwaysOn Scope and Architecture This is the first post in a series to provide step-by-step instructions on how to setup and configure a SQL Server 2012 AlwaysOn in a dual data-center Windows clustered environment…
It is commonly known that when using SQL Server with Active Directory you need to utilize the DOMAIN\UserName format and that the UserName cannot be more than 20 characters. If you do use a name with more than 20 characters…
SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11 KB Article: KB #2812683 Build number is 10.50.2869 Applicable to @@VERSION 10.50.2500 through 10.50.2868 SQL Server 2008 R2 Service Pack 2 Cumulative Update # 5 KB Article: KB #2797460 Build number…
Hello, I’m happy to see that the buzz word “Free” did not fail to attract readers. NEVER FEAR! You will not leave this post disappointed. I’m not going to try and do a better job than John Sansom has already…
Background The days of restarting SQL Service with trace flags 1204 or 1222 (MSDN Detecting and Ending Deadlocks) or being forced to start up a profiler trace are no more. Let’s face it. There are times when someone comes up…
Today I’m happy to be able to relay some troubleshooting information that I found extremely difficult to find on the internet. Partly because the symptoms don’t present themselves in a manner that easy leads to the real issue. Cluster Explanation:…
MS SQL Server provides a wide range of options to choose from when deciding how to regulate security in our organizations? I’m curious how you handle it? Do you go full on best practice and run Windows Authentication only, allow…
We are all familiar with table variables, local temp tables, and global temp tables but what some people over look is that stored procedures and functions can also utilize tempdb. I imagine that the reason for this oversight is because…
One challenge for a DBA is to setup the appropriate backup plans for the databases under our responsibility. It is easy to use SSMS’s maintenance plans to get the job done or even just write a simple BACKUP DATABASE command…
Recently I found myself involved in a project where a tab delimited text file (updated daily) was being imported into a MS SQL Server 2008 R2 database and then the single imported table was manipulated into a handful of others…