Always Encrypted a new feature on SQL Server 2016
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
Category: DBMS
How to view a deadlock graph using the information from the default SQL Server 2008 system_health session?
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?
Have you already tried sqlpowerdoc?
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?
How to access the SQL Server Configuration Manager using registered servers
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
A great post on DBCC CHECKDB
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
DBCC Showcontig and the ideal Extent Scan Fragmentation Value
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
Free Training in October
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
SQL Server 2008 R2 Service Pack 2 Download
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
Free Tool to Manage SQL Server
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
SQL Server virtual labs
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
IgnacioSalom.com 