When you look at the installed programs with SQL Server 2014 CTP1 you see the following: There is no BIDS or Visual Studio installed with CTP1 of SQL Server 2014. After some additional research, and discovering that I didn’t miss …
No more Business Intelligence Development Studio in SQL 2014 Read more »
Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday we took a look at CTEs for Data Paging, today we will build on what …
Day 14 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s and how it compares to the offset and fetch in T-SQL 2012. Now on to CTE Data Paging. These queries …
Beta 6 just release for the Database Health Reports with a few new features. Since the I received a couple requests to add new features, so I added a page to the Database Health Reports page where people can request features, and …
New Database Health Reports – Feature Request Page Read more »
It was a great day at SQL Saturday today. I was able to preview my Common Table Expressions Book at my Common Table Expressions presentation. The presentation was great, the room was packed, and there were lots of great questions. …
Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all of the parsed query plans out of memory. This is commonly used in development environments, …
SQL Server 2012 adds a new function called DateFromParts. This new function simplifies the creating of a DATE type in TSQL over the older ways of doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in …
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause. These enhancements are often times referred to as the windowing functions. Want to learn more …
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 at http://databasehealth.stevestedman.com. You can use the Database Health Reports to increase the overall health …
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 …