For all DBAs working in banks or other organizations that need to comply with PCI DSS, segregation of duties is … Continue reading Always Encrypted a new feature on SQL Server 2016
Back in 2009 Jonathan Kehayias wrote an article on SQL Server Central with the title “Retrieving Deadlock Graphs with SQL … Continue reading How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
Today I read an amazing post by Kendal Van Dyke. In the post he gives great news, he introduces SQLPowerDoc. … Continue reading Have you already tried sqlpowerdoc?
A few days ago I was talking to my friend Roman Bondar about how handy is to use the SQL … Continue reading How to access the SQL Server Configuration Manager using registered servers
Aaron Bertrand wrote a great post on DBCC CHECKDB. He advices on different ways on performing DBCC CHECKDB. His post … Continue reading A great post on DBCC CHECKDB
A few days ago I got a question about the ideal value for “Extent Scan Fragmentation”. That is why I … Continue reading DBCC Showcontig and the ideal Extent Scan Fragmentation Value
Pragmatic Works, SQL Server Central and Microsoft are giving free training. If you want more information about it, please visit … Continue reading Free Training in October
On the 26th of July Microsoft released SQL Server 2008 R2 Service Pack 2(SP2). You can find a post on … Continue reading SQL Server 2008 R2 Service Pack 2 Download
If you have not heard of SSMS Tools Pack, you will be probably very happy to read this post. Today a … Continue reading Free Tool to Manage SQL Server
I know christmas just passed, but I decide to give you a late gift. In this post I’m giving you … Continue reading SQL Server virtual labs