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 they are anything like last year these should be a blast. One of the new presentations that I have prepared for Redmond is the following: Getting Started as a Technical Speaker Have you considered speaking …
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 have been added. The main focus on this beta was fixing bugs, increasing stability and a new more solid setup program. My favorite part of the application is the historic waits advisor, which allows you …
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 recommended that the collation of your database match the collation TempDB. It is possible that if your collations do not match that you may get errors, or that queries using TempDB will not run …
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 Faster” Switch The NO_LOCK hint is often believed to be the “Run Faster” switch, but in reality can cause some very inconsistent results. Explore alternatives to the NO_LOCK hint to get your queries to run …
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 of IDENTITY 9,223,372,036,854,775,807 IDENTITY values out of a BIGINT in SQL Server. Which in easier terminology is 9 with roughly 18 …
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 data type category, except for the bit data type, or decimal data type. So how many rows can you insert into that table? It depends on the data type used. BIGINT maximum value is 9,223,372,036,854,775,807 …
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 WASTES OR MUDA ARE: Transportation Inventory Motion Waiting Over-Processing Over-Production Defects These all apply to software development in similar ways as they apply to a manufacturing facility. For instance: Transportation refers to moving things, which …
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 quick to fix. I was able to get these fixed, along with one other bug fix, once they were all tested, I launched Beta 3.1 of the Database Health Reports. For anyone who downloaded Beta 3 …
Database Health Version 3.1 So Soon After Beta 3 Read more »
One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it continuously monitors your SQL Server database and logs the details around queries that are causing waits. Here is an example, the following ugly block of TSQL updates a table with a few million rows in …
Finally after a month and a half of preparation on Beta 3 of the Database Health Reports, it will be released tomorrow. The biggest feature in Beta 3 is the historic monitoring. This process installs a small database to track wait times continuously, with a very small (less than 1%) on the database being monitored. Look for the download of …
Beta 3 of the Database Health Reports will be launched tomorrow. Read more »