Sites anglophones

Using sql_modules System Catalog View to Search Function and Stored Procedure Definitions

Publié le 19 juin 2017 sur

Search for code in any stored procedure or function in all SQL Server databases using sys.sql_modules system compatibility view using the following code. read more

[Video] Office Hours 2017/06/14 (With Transcriptions)

Publié le 19 juin 2017 sur

This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent’s pre-con for this year’s PASS Summit, and more. Here’s the video on YouTube: …

Modeling Many-to-Many relationships in SQL Server 2017 Graph Database

Publié le 19 juin 2017 sur

Relational databases do not natively support many to many relationships although a junction table is an easy workaround. Graph databases natively support many-to-many relationships. One of the first sample databases Microsoft provided for SQL Server wa …

Help for DBAs Who Support SSIS…

Publié le 19 juin 2017 sur

SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.

Extending DevOps practices to SQL Server databases – Story Tracking

Publié le 19 juin 2017 sur

Join Microsoft Data Platform MVP Grant Fritchey for the next Database DevOps demo webinar. He’ll be plugging Redgate tools into Atlassian’s Jira, Bitbucket, and Bamboo, as well as showing how you can integrate database changes, code, and issues. …

Scoring Outliers with R

Publié le 19 juin 2017 sur

What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.

SQL SERVER – PowerShell Script – Remove Old SQL Database Backup Files From Azure Storage

Publié le 19 juin 2017 sur journey to sqlauthority

Earlier back, I wrote blog to help my blog reader SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage As they say, there’s more than one way to skin a cat. One of my blog reader shared another …

Top SQL Server Database Management Challenges and Tracking SQL Server Databases

Publié le 19 juin 2017 sur

Sponsored by: IDERA Date: Wednesday, August 16, 2017 at 2:00 PM EDT – Duration: 1 hour read more

Father, Son, Daughter, and SQL

Publié le 18 juin 2017 sur

I don’t love Father’s Day. Mostly because I spoke to my father for the last time on Father’s day back in 1996. He wasn’t feeling well, we exchanged a few pleasantries, and the words I remember were: « I don’t feel well, let me give you to your mother. » …

Using Hyper-V for SQL Server CTP and RC Versions

Publié le 18 juin 2017 sur

Yesterday at SQL Saturday I was asked how to connect to SQL Server 2017 CTP 2.1 that was running in a virtual machine by using Remote Desktop Connection. If you want to learn how to use new software before it is released, running it in a virtual machin …

We Are Part of an Awesome Community

Publié le 18 juin 2017 sur

As I type, SQL Saturday-Dublin 2017 is winding down for me. There’s a Viking Splash Tour planned for tomorrow but I’m off to London to deliver some Biml Training and will have to miss the fun. Reflecting on my first trip to Ireland, it occu …

How to Write Case Statement in WHERE Clause? – Interview Question of the Week #127

Publié le 18 juin 2017 sur journey to sqlauthority

Question: How to Write Case Statement in WHERE Clause? Answer: This is a very popular question. This question usually comes up in the context of writing search condition where the user is not sure if there will be condition or not. Recently, durin …

SQL Server 2017 Graph Database References

Publié le 17 juin 2017 sur

This is a list of references I used in creating my SQL Saturday presentation on SQL Server 2017 graph databases. To get started with the graph database features of SQL Server 2017, I recommend that you start with the following official Microsoft docume …

WordPress – How to Rollback Plugin or Theme Changes? – WP Rollback

Publié le 17 juin 2017 sur journey to sqlauthority

This post is not about SQL Server but WordPress. As many of you know that I host on self hosted WordPress. This blog is powered by PHP and MySQL and hosted on an Apache Server. If you are familiar with WordPress Hosting, I am sure your …

Query Plans: Trivial Optimization vs Simple Parameterization

Publié le 16 juin 2017 sur

Facemaking You know when you think you know something, and the obviousness of it makes you all the more confident that you know it? That’s usually the first sign that there’s a giant gotcha waiting for you. And that’s what happened to …

Pages :