This week I will be attending and speaking at Vancouver DevTeach. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. Monday and Tuesday I have morning presentations which leaves the rest of …
The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to …
Working on my sessions for DevTeach in Vancouver in December. Read more »
Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main …
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently working on adding a new feature into the Database Health Reports to analyze T-SQL Technical Debt. If …
Working on the T-SQL Technical Debt feature in the Database Health Reports Read more »
Over the last 3 months I have been working on a number of new features, enhancements and bug fixes to the Database Health Reports Project. In the next day or two Beta 6 will be available. If you are not familiar …
Being day one of DBBC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKALLOC. Description: DBCC CheckAlloc checks and can repair disk space allocation structures for a database. DBCC CheckAlloc checks the allocation for all pages in the …
After writing a recent blog post on Are you wasting half the capacity of IDENTITY, I started thinking about how much is too big for an BIGINT IDENTITY. If you don’t know about, you can get Are you wasting half the capacity …
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and …
Index Statistics Report added to the FREE SQL Server Health Reports Read more »
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of the two. Who knows if my session will get accepted, but I am giving it …
A restore plan of course is far more important than the backup plan. When things go wrong and you need to restore a database backup, that is not the time to be learning how to do a restore, or to …