Sites anglophones


The 3rd edition of the ebook SQL Server Execution Plans

Publié le 24 octobre 2018 sur sqlblog.com
 

From Redgate website you can download (for free) the ebook SQL Server Execution Plans written by Grant Fritchey and technically reviewed by Hugo Kornelis.This ebook can not be miss in your digital library!Enjoy! 

SQL Server Diagnostic Information Queries for October 2018

Publié le 24 octobre 2018 sur sqlskills.com - glen berry
 

This month, I have just made some minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works …

Batch Mode For Row Store: What Does It Help With?

Publié le 24 octobre 2018 sur brentozar.com
 

SQL Server 2019 Introduces something pretty cool: the ability for row store indexes to be processed in batch mode. Batch mode is, of course, the preferred processing realm of column store indexes. If you’re still in the dark about column store, y …

Generate HTML Formatted Email of SQL Server Database Consistency Check Errors

Publié le 24 octobre 2018 sur sqlservercentral.com
 

In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.

Basic Administration Tasks – Level 5 of the Stairway to for Azure SQL Database

Publié le 24 octobre 2018 sur sqlservercentral.com
 

In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.

Free eBook: SQL Server Backup and Restore

Publié le 24 octobre 2018 sur sqlservercentral.com
 

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSM …

SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine Via T-SQL?

Publié le 24 octobre 2018 sur journey to sqlauthority
 

Earlier last year, I had posted a very interesting blog post which still today gets quite a lots of interest is SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?. In the recent Comprehensive Database Performance Health …

How to See Execution Plans in Azure Data Studio

Publié le 23 octobre 2018 sur brentozar.com
 

Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. It’s still relatively young, so it has some missing areas of functionality. When you run DMV queries to look at query plans, they show up as XML, which isn’t v …

You probably didn’t go to a training class this year. Again.

Publié le 23 octobre 2018 sur brentozar.com
 

“Can someone just give me a tl;dr?” The year is drawing to a close, and you didn’t go to a training class. Again. Your skills aren’t keeping up. You keep bookmarking blog posts about new database stuff, interesting scripts you w …

Posting SQL Server notifications to Slack

Publié le 23 octobre 2018 sur sqlservercentral.com
 

Learn how you can post notifications from SQL Server directly to a Slack channel.

Scheduling SQL Server Tasks on Linux

Publié le 23 octobre 2018 sur sqlservercentral.com
 

In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.

Highlighting Personally Identifiable Information (PII) across SQL Server instances and databases

Publié le 23 octobre 2018 sur sqlservercentral.com
 

With the recent regulatory pressures such as GDPR, being able to know what type of data we are holding onto within our business became a bigger challenge. At Redgate, we have been exploring ways to make this easier for our heavy SQL Server users and el …

SQL SERVER – How to DROP Multiple Tables Using Single DROP Statement?

Publié le 23 octobre 2018 sur journey to sqlauthority
 

In my earlier post, SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)? I showed you how to DROP Statement multiple tables together using a wizard in SQL Server Management Studio (SSMS). Lots of develo …

New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance

Publié le 22 octobre 2018 sur sqlskills.com - paul randall
 

Tim’s been working closely with the development team on Azure Managed Instance, presented with them at Ignite recently, and has been presenting internally at Microsoft field offices to their clients, as well as working with our own clients extens …

Announcing The Team Membership

Publié le 22 octobre 2018 sur brentozar.com
 

You have a team of database developers and DBAs – SQL Server professionals who want dedicated help. You want a predictable bill that includes training, mentoring, consulting meetings, and career growth. In The Team Membership, you get: Live …


Pages :