Now that Database Health Beta 2 is out, whats next…
Now that Beta 2 of the Database Health Project is out, and people are using it, I am going to focus my attention on 2… Read More »Now that Database Health Beta 2 is out, whats next…
SQL
Finding the contents of the Plan Cache
I often get asked “how do I find the contents of the SQL Server Plan Cache?” My first response is just use the Database… Read More »Finding the contents of the Plan Cache
TSQL to Determine Plan Cache Size
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here… Read More »TSQL to Determine Plan Cache Size
SQL Saturday Sponsor..
I just signed up as a SQL Saturday sponsor. Here is the logo that I put together to use for the sponsorship link. Good thing… Read More »SQL Saturday Sponsor..
SQL Lunch UK
Today I started the day early with a great presentation for the SQL Lunch UK group on Common Table Expressions. For those who attended the… Read More »SQL Lunch UK
My Top 10 TSQL Enhancements in SQL Server 2012
So far after playing around with SQL Server 2012 there are many new features to SQL. Overall I think my favorites are in the Analytic… Read More »My Top 10 TSQL Enhancements in SQL Server 2012
New DMV in SQL Server 2012 sys.dm_server_services
One of the new Dynamic Management Views introduced in SQL Server 2012 is the dm_server_services which returns info on the services running that are associated with SQL… Read More »New DMV in SQL Server 2012 sys.dm_server_services
No more Business Intelligence Development Studio in SQL 2012
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that… Read More »No more Business Intelligence Development Studio in SQL 2012
CTE – With An Insert Statement
Queries with Common table expressions (CTE) are made up of two parts, the CTE part, and the SQL that references the CTE. In preparation for… Read More »CTE – With An Insert Statement
SQL Server Developer Edition – Under $50
Having taught several Introduction to SQL Server classes, it is always a challenge for new users to get SQL Server running on their computer for… Read More »SQL Server Developer Edition – Under $50