13th Anniversary of SQL Authority – 4918th Blog Post
Today is Anniversary of SQLAuthority and it completes 13 years and this is a 4918th blog post. That means on average every year I have published around 378.3 blog posts a year. Let us read the blog about 13th anniversary.13 years ag …
What you need to consider for your monitoring strategy in 2020
The post What you need to consider for your monitoring strategy in 2020 appeared first on SQLServerCentral.
Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer
The post Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer appeared first on SQLServerCentral.
My annual Black Friday sale starts tomorrow. Here’s what you wanna know.
The time is almost here – the moment you’ve been waiting for all year. I’ve sharpened my pencils to take the prices as low as I can possibly take ’em: Level 1: Fundamentals$295Recorded Class Season PassSQL ConstantCare®The C …
SQL SERVER – Creating a Nonclustered Columnstore Index on Temp Table
Recently I was delivering training on SQL Server Performance Tuning and during the session, I received a very simple question about the nonclustered columnstore index on a temp table.The question was is it possible to create columnstore index on a temp …
Accelerating Database Recovery with SQL Server 2019
The post Accelerating Database Recovery with SQL Server 2019 appeared first on SQLServerCentral.
Using OFFSET for Paging
Paging is a common query that developers will use when retrieving results from a table. Often an application may want to display 10 or 20 results, knowing there might be 100 or more. The first request could be using just the top 10, with subsequent req …
SQL Productivity with SQL Prompt
The post SQL Productivity with SQL Prompt appeared first on SQLServerCentral.
Updated sys.dm_os_waiting_tasks script to correctly parse nodeId
I realized that I’d fixed an issue with my sys.dm_os_waiting_tasks script to correctly parse out the parallelism nodeId from the resource_description column (as newer versions include more info after the nodeId=X info) but I never blogged th …
New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364)
Tim’s latest Pluralsight course has been published: SQL Server: Understanding Database Fundamentals (98-364). It’s just over 2 hours long, and from the course description: It is very common for databases to be part of a compa …
Other Data People are Getting Ahead of You.
The next time you need to look for a job, I’ve got some bad news for you. A lot of other people are gonna stand out from the crowd and get way, way ahead of you in the line. They’ve learned how to save their companies money. They’ve l …
SQL SERVER – Using NEWID vs NEWSEQUENTIALID for Performance
I really like my work as every single day I get to see different SQL Server and new interesting problems to solve when I work with Comprehensive Database Performance Health Check. Recently, while working with a client we noticed that they have a huge i …
Splitting a SQL Server Table Over Multiple Files
The post Splitting a SQL Server Table Over Multiple Files appeared first on SQLServerCentral.
57% of Your Bosses Are Cheap. (Well, maybe 100% of your boss in particular.)
You know what I’ve noticed about companies? Some companies buy tools for you, but they just don’t have a training budget. They believe they hired you to solve problems, and you should have come with the knowledge to get your job done …
SQL Server Performance Tuning Recorded Class – 40% Discount for 4 Days
I have been blogging on SQLAuthority.com for almost 13 years. Well, to be honest, I will be completing the 13th year on November 1, 2019. I did my very first blog post on November 1, 2006, and since that day, I have been pretty much blogging every sing …