SQL Short – Aggregation Class
Today I am pleased to announce that we have a new course available at Stedman SQL School. This is our second class in the SQL Short series, which is a set of short but focused courses to help improve your …
Today I am pleased to announce that we have a new course available at Stedman SQL School. This is our second class in the SQL Short series, which is a set of short but focused courses to help improve your …
For some reason, you want to learn how to use SQL Server, but the steps to get started can be overwhelming. I have created a Getting Started with SQL Server class that we sell for just $19.99. At that price …
The question comes up occasionally about how people can get started with Microsoft SQL Server? This is often people who are working and for some reason need to learn how to use SQL Server in their jobs. They ask me, …
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
This sale only happens 1-2 times a year – get it while it’s hot! SQL Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those …
So you have a new team member that has just joined your team, and they have no experience with SQL Server, but they need to learn how to get connected and use SQL Server. There are a few options on …
Getting that New Team Member Started with SQL Server Read more »
Looking at the memory limits and other limits on the SQL Server versions over time, we have seen things increase, but one limit that is still very low is the memory limit for SQL Express. Specifically the maximum memory for …
In 2012 SQL Server introduced the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years. I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers …
TSQL Pivot Table TSQL Pivot Table? What’s that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below creates a database called pivot, you probably already have your own database …
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it really comes down to is speed, for tables with a large number of rows, and thus …