Beta 4 of the Database Health Reports
Just a reminder, we are a couple weeks into beta 4 of the database health reports. If you haven’t tried it out, take a look… Read More »Beta 4 of the Database Health Reports
SteveStedman
Using a CTE to Split a String Into Rows with Line Numbers
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String… Read More »Using a CTE to Split a String Into Rows with Line Numbers
SQL Saturday Update.
There are 2 upcoming SQL Saturday events that I have pitched presentations at. These are Vancouver SQL Saturday 198, and Redmond SQL Saturday 2012. If… Read More »SQL Saturday Update.
Database Health Reports- Beta 4 now available.
Today I released Beta 4 of the Database Health Reports. It has been 2 months since Beta 3, and several bug fixes and new features… Read More »Database Health Reports- Beta 4 now available.
Cannot resolve the collation conflict
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is… Read More »Cannot resolve the collation conflict
Sessions submitted to SQL Saturday Vancouver BC
I had so much fun at SQL Saturday in Vancouver BC last year, I have decided to go again. The sessions submitted are: The “Run… Read More »Sessions submitted to SQL Saturday Vancouver BC
How BIG is too BIG for a BIGINT IDENTITY?
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… Read More »How BIG is too BIG for a BIGINT IDENTITY?
Are you wasting half the capacity of IDENTITY?
When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer… Read More »Are you wasting half the capacity of IDENTITY?
Muda – or the 7 Deadly Wastes
In the manufacturing world it is referred to the 7 wastes, or the Japanese term Muda. How does this apply to software development. THE 7… Read More »Muda – or the 7 Deadly Wastes
Database Health Version 3.1 So Soon After Beta 3
Today I release Beta 3.1 of the Database Health Reports. Immediately after the release of Beta 3, there were 3 bugs reported that were very… Read More »Database Health Version 3.1 So Soon After Beta 3