Subscribe to this blog
Everyday SQL
Patrick Keisler is a MCTS and MCP. For over 12 years, he has been been a database administrator for a major investment bank, Wells Fargo Securities. During that time, he has gained considerable knowledge in Microsoft SQL Server by supporting hundreds of applications ranging from high-volume trading applications to massive data warehouses.
Archives: March 2013
Use Powershell to Pick Up what Database Mirroring Leaves Behind
Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from log shipping. However, like log shipping, it is still only a database-level disaster recovery solution. Meaning that any logins, server role memberships or server-level permissions will not be mirrored over…
0 comments, 527 reads
Posted in Everyday SQL on 26 March 2013
T-SQL Tuesday #40 - Proportional Fill within a Filegroup
0 comments, 948 reads
Posted in Everyday SQL on 12 March 2013
Dealing with a Fragmented Heap
Just for the record, this happens to be one of my favorite interview questions to ask candidates.
At some point in time, there will be a database containing tables without clustered indexes (a heap) that you will be responsible for maintaining. I personally believe that every table should have a…
0 comments, 783 reads
Posted in Everyday SQL on 5 March 2013