Sites anglophones

SQL SERVER – Enabling Older Legacy Cardinality Estimation

Publié le 9 février 2019 sur journey to sqlauthority

Yesterday, I had a very interesting situation, one of our Comprehensive Database Performance Health Check client immediately called me on Skype with his entire server going continuously stopping due to a very toxic poison wait type of Re …

[Video] An Introduction to GitHub for DBAs

Publié le 8 février 2019 sur

Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved? I’m with you: I hated GitHub. For years, I strugg …

SQL SERVER – Find Out Current Language of the Session

Publié le 8 février 2019 sur journey to sqlauthority

After reading my post SQL SERVER – Puzzle – Playing with DateTime with Customer Data, one of my blog readers asked me “How to find out the current language setting of the session?” With the help of the system variable and system …

Apache Cassandra Data Modeling and Query Best Practices

Publié le 7 février 2019 sur

Apache Cassandra database is a distributed, fault tolerant, linearly scalable, column-oriented, NoSQL database. Apache Cassandra is great at handling massive amounts of structured (table has defined columns), and semi-structured (table row doesn’ …

DevOps Without the Database: A Cautionary Tale

Publié le 7 février 2019 sur

You hear often how DevOps doesn’t work with databases, or conversely that the people responsible for databases don’t work with DevOps. Neither should be true, but both frequently are. When people say that “DevOps doesn’t work wi …

What Queries Does Microsoft’s Telemetry Service Run On Your SQL Server?

Publié le 7 février 2019 sur

I was working in my lab and I was having some odd blocking waits that I wasn’t expecting. I started firing up sp_WhoIsActive to see what queries were running, and I got a rather odd surprise: sp_WhoIsActivelyRunningTelemetryQueries (click to see …

Keeping sensitive Data secure outside of Production

Publié le 7 février 2019 sur

Part of the complication of implementing DevOps into database development is the involvement of data. Microsoft MVP Grant Fritchey explores the use of dynamic data masking and the strategies that can protect the data when it moves into less secure envi …

Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly

Publié le 7 février 2019 sur journey to sqlauthority

I am not sure what changes I made in one of my Virtual Machine, but I was running into an issue. In this blog, we would discuss how to fix error “The ‘SqlStudio Profile Package’ package did not load correctly” while launching Vi …

The Next Mastering Series is About to Start. Wanna Save $2,000?

Publié le 6 février 2019 sur

Ever wanted to take my Mastering series of classes? I recommend that you take ’em in a specific order because each class builds on the next. If you try to parachute in out of order, you’re gonna have a bad time. The next rotation is about t …

Import data dynamically using R and Python in Power BI Desktop

Publié le 6 février 2019 sur

Learn how to import data into Power BI using either R or Python scripts.

How SQL Provision completes the Database DevOps story

Publié le 6 février 2019 sur

Database DevOps is not without its challenges. When SQL Provision is introduced into the tool chain it can enable organizations to reduce the burden on network resources, minimize administrative tasks and accelerative database delivery updates. Tony Da …

Stairway to Data, Level 1: The Basics

Publié le 6 février 2019 sur

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you’re likely to meet when handling data in databases

SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?

Publié le 6 février 2019 sur journey to sqlauthority

One of my existing clients has sent me an interesting question. In this blog, I would share one interesting situation where my client has created an availability group and it was visible in SSMS, but no role was visible in failover cluster manager. Her …

Avoiding SQL Server Upgrade Performance Issues

Publié le 5 février 2019 sur - glen berry

As SQL Server 2008 and SQL Server 2008 R2 rapidly approach the end of Extended support from Microsoft on July 9, 2019, and with SQL Server 2014 also falling out of Mainstream support on July 9, 2019 (joining SQL Server 2012, which fell out of Mainstrea …

Registration Open for My Upcoming Pre-Cons: Belgium, Dallas, Iceland, Israel, Miami, Orlando!

Publié le 5 février 2019 sur

I’m hitting the road this spring. Here’s where to find me in person: SQLSaturday Iceland – Your First SQL Server Performance Tuning Class – March 16 – You’re stuck with a database server that’s not going f …

Pages :