Sites anglophones


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 …

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 …

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.

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 …

Thank you, #sqlfamily, for donating to The Trevor Project.

Publié le 22 octobre 2018 sur brentozar.com
 

A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for The Trevor Project, and how we’d match up to $5,000 of your donations. This weekend, you did it. You hit the $5,000 mark. I’m so proud of yo …

Merging a Conflict with SQL Source Control and Beyond Compare

Publié le 22 octobre 2018 sur sqlservercentral.com
 

This article describes a simple example of what it’s like to merge a conflict in SQL Source Control. You will need to have installed Beyond Compare, one of the tools which integrates with SQL Source Control to resolve conflicts.

Generate QR Code® barcodes in an SSRS report with the QRCoder library

Publié le 22 octobre 2018 sur sqlservercentral.com
 

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was …

SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL

Publié le 22 octobre 2018 sur journey to sqlauthority
 

As you might already know that I am a SQL Server Performance Tuning Expert who also acts as a “on-demand consultant” for many organizations across the world who have performance tuning or any other issue related to SQL Server. Once I was wo …

Calling all user group leaders! We want to present for you in 2019!

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

By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2018! We’d love to present remotely for your user group in 2019, anywh …

[Video] Office Hours 2018/10/17 (With Transcriptions)

Publié le 21 octobre 2018 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss small vendor apps, “Slow in the Application, Fast in SSMS?”, virtualization, licensing, msdb backup history issues, implicit transactions, how to convince your boss to allow you to use sp_blitz, an …


Pages :