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?
SQL Server
Beta 3 is Now Available.
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… Read More »Beta 3 is Now Available.
5 Days Until Beta 3 of the Database Health Reports
5 days until Beta 3 of the Database Health Reports. Coming soon, and this one is going to be cool. Although Beta1 and Beta2 had… Read More »5 Days Until Beta 3 of the Database Health Reports
Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday
Thanks to everyone who attended my CTE presentation at SQL Saturday in Olympia Washington today. Have a great rest of the day. As promised I have… Read More »Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday
Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
I just finished the Exploring the TSQL Enhancements in SQL Server 2012 presentation at SQL Saturday 166 in Olympia Washington. Thanks everyone who attended, I hope… Read More »Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code
SQL Server 2012 – SEQUENCE
SQL Server 2012 introduces the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I… Read More »SQL Server 2012 – SEQUENCE
SQL Server 2012 SP1 Now Available From Microsoft
Today Microsoft Release Service Pack of of SQL Server 2012. My preference is to never run a new version of SQL Server in a… Read More »SQL Server 2012 SP1 Now Available From Microsoft
Unleashing Common Table Expressions in SQL Server – Slides and Sample Code
Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today. Have a great rest of the day. As promised… Read More »Unleashing Common Table Expressions in SQL Server – Slides and Sample Code
Database Health Reports – Historic Waits Report Sneak Preview
Coming in the next beta of the Database Health Report is a new feature called the Historic Reports which installs a small database to track… Read More »Database Health Reports – Historic Waits Report Sneak Preview
Adventureworks2012 data to Google GeoChart Visualization
There are so many cool tools available today for data visualization. This posting covers pulling data from the AdventureWorks2012 database running on SQL Server… Read More »Adventureworks2012 data to Google GeoChart Visualization