Sites anglophones


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 …

TOP vs Max/Min: Is there a difference?

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

Is there a difference between using TOP and MAX/MIN to return and end value to a table?

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 …

SQL SERVER – Error 21028 : Replication Components are not Installed on This Server

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

One of my clients, for whom I installed SQL Server and configured AlwaysOn came back to me with an error message. While trying to configure replication they were getting an error message. In this blog, we would learn how to fix error “Microsoft S …

How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204

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

Question: How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? Answer: Before I answer this question, I must acknowledge that I have never heard this question in my 20 years career before and I must ask you back, where do you co …

SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server

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

One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well. In a recent engagement, one of their developers asked a quest …

SQL Server Diagnostic Information Queries for December 2018

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

This month, I have just made some more minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the …

What Azure SQL DB Managed Instances Don’t Support (Yet)

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

Whenever a new product or feature comes out, I like keeping an eye on its support forums to understand the challenges users are facing. I went through Azure SQL DB’s Managed Instance feedback forum, and here are some of the interesting issues tha …

Review your SQL Server permissions with SQL Census (in preview)

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

SQL Census allows users to gain a clear picture of SQL Server access, from SQL roles and permissions to Active Directory account and group memberships. The tool provides a simplified view of these permissions, along with the path by which they were gai …


Pages :