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
SQL Server
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
Getting Started with SQL Server?
Everyone has their story of how they got started with SQL Server, and they range quite a bit. You might be that developer that was… Read More »Getting Started with SQL Server?
Announcing our Newest SQL Server Course
We are pleased to announce our our new SQL Server Course >>>”Getting Started with Microsoft SQL Server” <<< We are launching this course with a… Read More »Announcing our Newest SQL Server Course
Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS
Steve Stedman So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever it was… Read More »Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS
Are you wasting half the capacity of IDENTITY?
When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer… Read More »Are you wasting half the capacity of IDENTITY?
Get a List of Tables That Are Compressed
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression… Read More »Get a List of Tables That Are Compressed
Finding the names of all indexes on a SQL Server
I needed a way to list the indexes for an entire database, but I was running into a problem using sys.indexes that I could only… Read More »Finding the names of all indexes on a SQL Server
New cumulative update for SQL Server 2017
Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE.… Read More »New cumulative update for SQL Server 2017