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… Read More »SQL Short – Aggregation Class
SQL
Do You Want to Learn How to Use SQL Server?
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… Read More »Do You Want to Learn How to Use SQL Server?
How Do I Get Started with SQL Server?
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… Read More »How Do I Get Started with SQL Server?
October SQL Daily Monitoring – SQL Server Versions
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… Read More »October SQL Daily Monitoring – SQL Server Versions
20% Off Mentoring Services
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… Read More »20% Off Mentoring Services
Getting that New Team Member Started with SQL Server
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… Read More »Getting that New Team Member Started with SQL Server
Memory Limit for SQL Server Express
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… Read More »Memory Limit for SQL Server Express
SQL Server SEQUENCE
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.… Read More »SQL Server SEQUENCE
August Blog Post Wrap-up
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.… Read More »August Blog Post Wrap-up
Index Seek vs Index Scan
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… Read More »Index Seek vs Index Scan