Sites anglophones

SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)

Publié le 19 mars 2019 sur journey to sqlauthority

One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s) Here is the complete error message they were seeing while all of the sched …

Poll Results: What Conference Schedule Did You Prefer?

Publié le 18 mars 2019 sur

Last week, I asked you a couple of questions: When you attend a 1-day conference like a SQLSaturday or SQL Relay, what is your preferred session schedule? You said: 31.8% (211 votes): 6 60-minute sessions 31.3% (208 votes): A mix of 45-minute and 90-mi …

Have your say on the state of SQL Server monitoring

Publié le 18 mars 2019 sur

In this blog, we review the key insights from last year’s State of SQL Server Monitoring report. One year on, how has this changed? Read the blog to find out how you can help us define the state of 2019 plus a chance to win a $250 Amazon voucher.

Migrating SQL Server Reporting Services

Publié le 18 mars 2019 sur

Learn how to migrate SSRS by following a walk through of migrating SSRS 2014 to SSRS 2016.

SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group

Publié le 18 mars 2019 sur journey to sqlauthority

This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message. And here is the text of error message. Operation to create resource group stretchgroup-austral …

Data Quake

Publié le 18 mars 2019 sur

Data Quake. That’s what it is. Dave Wells have just gave this great definition that clearly describes what’s happening in the data management world during the recent years.I am greatly enjoying Dave’s session today at Enterprise Data World s …

Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216

Publié le 17 mars 2019 sur journey to sqlauthority

Question: Do Queries Always Respect Cost Threshold of Parallelism? Answer: No. Not Always. Let us do a quick test about it. First, let us set the Cost Threshold of Parallelism for my query to 10 and Max Degree of Parallelism to 0 for my server. I have …

SQL SERVER – List Query Plan, Cache Size, Text and Execution Count

Publié le 16 mars 2019 sur journey to sqlauthority

I love the curious questions from people who attended the class. Here is one such question during recent SQL Server Performance Tuning Practical Workshop. Let us see the question which I received about the Query Plan. How do I find out query plan, cach …

Create Power BI Connection to Azure SQL Database

Publié le 15 mars 2019 sur

Learn how to use Power BI to retrieve data from an Azure SQL Database.

SQL SERVER – Difference Between Status in SP_Who2 – Running, Pending, Runnable, Suspended, Sleeping

Publié le 15 mars 2019 sur journey to sqlauthority

One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards t …

How to Handle Power Grid Failure

Publié le 15 mars 2019 sur - glen berry

The Blizzard On March 13-14, 2019, most of eastern Colorado experienced a pretty severe blizzard. A blizzard is when you have snow combined with sustained winds of 35 mph or more that last for three hours or more. This storm was unusual because it was …

What are students saying about my latest round of classes?

Publié le 14 mars 2019 sur

Mastering Index Tuning has a fresh set of reviews from the latest students. Levente Kalotai wrote: Absolutely loving it. The class, Brent style, everything. I have to admit, I had my reservations before the class, but boy I was wrong about it. Less tha …

Read, Enrich and Transform Data with AWS Glue Service

Publié le 14 mars 2019 sur

More and more companies are aiming to move away from managing their own servers and moving towards a cloud platform. Going serverless offers a lot of benefits like lower administrative overhead and server costs. In the serverless architecture, develope …

Building Better Stored Procedures

Publié le 14 mars 2019 sur

In a followup, this article includes discussion of more advanced features of using stored procedures.

SQL Monitor 9 – Proactively Monitor Large SQL Server Estates

Publié le 14 mars 2019 sur journey to sqlauthority

Let me tell you about a real-world scenario which I often see at organizations I work with. In the perfect world, as organizations grow, their team should grow too. But often that isn’t the reality. The way it works out in most cases is, when org …

Pages :