A minor DMV with SQL Server this particular one doesn’t really provide much information about the OS other than the version and service pack level. It is nowhere […]
sys.Dm_db_database_page_allocations()
This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]
A new video on DB mirroring
Well it’s not new exactly it was created many years back and I somehow never uploaded it. Yesterday a former client came back asking about DB mirroring and […]
administration / Azure / MSSQL
MS SQL Server 2014 to Cloud Backups – Part 1
In this series of blog posts the focus is going to be on the MS SQL Server 2014 Cloud backups feature. Most companies will easily be able to […]
Connecting to a Azure database from SSMS and how to configure database level Firewall
So you finally have an Azure database, but how do you connect to it? Surprisingly simple actually, you can access your database remotely from within SSMS so for […]
Creating a SQL Azure Server and Database
Have you ever wondered how to create a SQL Server and then a Database within the server that is managed within the Microsoft PaaS cloud know as Windows […]
Part 3 of 4: Video on Difference between partitioning and just multiple FGs
Sorry it took so long but here is the third video in our 4 part series on MS SQL Server partitioning. http://www.youtube.com/watch?v=GSNYGpNbidc I cover the difference between simple […]
At long last Pagination
MS SQL Server 2012 introduced a very nice feature for developers with the PAGINATION OFFSET Syntax. It has always been a challenge to work with pagination in MS […]
CHOOSE, Is MS really giving a choice?
In this blog we are going to talk about a little known T-SQL Command called CHOOSE. As its name suggests it allows some kind of selection to be […]