Sites anglophones


13th Anniversary of SQL Authority – 4918th Blog Post

Publié le 1 novembre 2019 sur journey to sqlauthority
 

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

Publié le 1 novembre 2019 sur sqlservercentral.com
 

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

Publié le 1 novembre 2019 sur sqlservercentral.com
 

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.

Publié le 31 octobre 2019 sur brentozar.com
 

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

Publié le 31 octobre 2019 sur journey to sqlauthority
 

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

Publié le 31 octobre 2019 sur sqlservercentral.com
 

The post Accelerating Database Recovery with SQL Server 2019 appeared first on SQLServerCentral.

Using OFFSET for Paging

Publié le 31 octobre 2019 sur sqlservercentral.com
 

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

Publié le 31 octobre 2019 sur sqlservercentral.com
 

The post SQL Productivity with SQL Prompt appeared first on SQLServerCentral.

Updated sys.dm_os_waiting_tasks script to correctly parse nodeId

Publié le 30 octobre 2019 sur sqlskills.com - paul randall
 

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)

Publié le 30 octobre 2019 sur sqlskills.com - paul randall
 

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.

Publié le 30 octobre 2019 sur brentozar.com
 

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

Publié le 30 octobre 2019 sur journey to sqlauthority
 

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

Publié le 30 octobre 2019 sur sqlservercentral.com
 

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.)

Publié le 29 octobre 2019 sur brentozar.com
 

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

Publié le 29 octobre 2019 sur journey to sqlauthority
 

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 …


Pages :