Sites anglophones


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 …

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?

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 …

Streamline Log Shipping Failovers: DR Made Just For You…

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

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.

SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted

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

It is indeed a pleasure when we write a timeless article for SQL Server and DBAs read it after many years. In the year 2007, I wrote an article about an error related to Could not open a new database. It has been one of the top viewed blog posts a …

Finding the Slowest Query in a Stored Procedure

Publié le 13 décembre 2018 sur SQLSkills.com - Erin Stellato
 

This post, Finding the Slowest Query in a Stored Procedure, originally appeared on the PASS website.  It has been re-posted here with permission.Figuring out exactly what causes slow performance for a stored procedure can sometimes feel like tryin …


Pages :