Sites anglophones


SQL SERVER – Writing Your First Subquery From a Single Table

Publié le 20 décembre 2018 sur journey to sqlauthority
 

My primary responsibility is to help different organizations with tuning their SQL Server Performance and here is the link to my most popular service SQL Server Performance Health Check. I often encounter complicated performance problems which are …

Performance and Stability Related Fixes in Post-SQL Server 2014 SP3 Builds

Publié le 19 décembre 2018 sur sqlskills.com - glen berry
 

As of December 12, 2018, there has been one Cumulative Update (CU) for the Service Pack 3 branch of SQL Server 2014. There were a relatively large number of hotfixes in this first cumulative update. If you are running on the SQL Server 2014 SP3 branch, …

SQL Server 2014 Service Pack 3 CU1 Released

Publié le 19 décembre 2018 sur sqlskills.com - glen berry
 

On December 12, 2018, Microsoft released SQL Server 2014 Service Pack 3 CU1, which is Build 12.0.6205.1. There are 13 hotfixes in the public fix list. If you are running SQL Server 2014, you should be planning on getting on the SP3 branch as soon as po …

Query Store And Cruel Defaults

Publié le 19 décembre 2018 sur brentozar.com
 

Gosh Darn Now, look, it’s no secret that I think Query Store is cool. Heck, I went and wrote sp_BlitzQueryStore so you can examine it similarly to how sp_BlitzCache looks at the plan cache. For a variety of reasons, though, we run into peopl …

SQL SERVER – Cannot Shrink Log File Because Total Number of Logical Log Files Cannot be Fewer than 2

Publié le 19 décembre 2018 sur journey to sqlauthority
 

Since I wrote my article about the script of shrinking the Log Files, there have been many emails from my blog readers about various messages which they are seeing during shrink. I have been sharing them with other blog readers as well. In this blog, w …

SSRS Reporting Basics: When is SSRS the Right Tool?

Publié le 18 décembre 2018 sur simple-talk.com
 

SQL Server Reporting Services (SSRS) is a server-based reporting tool, ideal for paginated reports. It represents a centralized approached to data governance, with all of your report files located on a central server. However, there are some self-servi …

Sniffed Nulls and Magic Numbers

Publié le 18 décembre 2018 sur brentozar.com
 

I Sniff Your Milkshake Building off of A Simple Stored Procedure Pattern To Avoid, I wanted to talk about a similar one that I see quite often that is not nearly as clever as one would imagine. I goes something like this: If this variable is passed in …

New Case Study: Ensuring HIPAA compliance with SQL Provision

Publié le 18 décembre 2018 sur sqlservercentral.com
 

New case study from Redgate. Since adopting SQL Provision, KEPRO, a leading US healthcare organization, have been able to achieve HIPAA compliance, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space.

Visualise SQL Server IO Stats

Publié le 18 décembre 2018 sur sqlservercentral.com
 

Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find …

SQL Server AlwaysOn Availability Groups Monitoring and Alerting – Part 2

Publié le 18 décembre 2018 sur sqlservercentral.com
 

In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-st …

SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.

Publié le 18 décembre 2018 sur journey to sqlauthority
 

I often get emails from my blog readers asking various types of clarifications about my own blog. Here is one of the interesting questions from a reader about message Cannot shrink file in the database to xxxx pages as it only contains yyyy pages which …

New class: Immersion Event on Power BI, Power BI Report Server, and SSRS

Publié le 17 décembre 2018 sur sqlskills.com - paul randall
 

No only has Tim been working heavily with Azure in 2018, he’s also been diving into the various reporting solutions that SQL Server has, and he’s ready to share his knowledge with the world in his new class on Power BI! It’s a two-day …

Comparison Review: Microsoft SSDT vs Redgate SQL Source Control

Publié le 17 décembre 2018 sur brentozar.com
 

Hi. I’m still not Brent. My name’s Alex, and I care about databases, DevOps and data protection. Last year I delivered a session on GroupBy all about how to do Database DevOps right, and back in May I wrote a blog post for BOU about how to …

[Video] Office Hours 2018/12/12 (With Transcriptions)

Publié le 17 décembre 2018 sur brentozar.com
 

This week, Erik and Richie discuss TSQL classes, scalar functions, index reorganize vs rebuild, daily image backups on a fringe SQL server on VMWare, number of databases per AG, best practices for ETL operations, and more! Here’s the video on You …

Database DevOps without compromising the data

Publié le 17 décembre 2018 sur sqlservercentral.com
 

Database DevOps has arrived and is here to stay. However this has also brought friction with the increasing importance of data privacy and protection. Redgate’s Compliant Database DevOps whitepaper outlines how you can introduce DevOps processes …


Pages :