Sites anglophones


SSIS: Read Event viewer with WMI Data reader

Publié le 5 mars 2019 sur sqlservercentral.com
 

Access OS event viewer and read it from a SSIS package using WMI Data reader task

Protecting Credit Card Data when Testing

Publié le 5 mars 2019 sur sqlservercentral.com
 

Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can h …

Price Increase Alert – SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019

Publié le 5 mars 2019 sur journey to sqlauthority
 

Just a quick note for everyone that if you have not signed up for my SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, so far, the price is going to be increased by USD 100 from March 1st. The price of the course inc …

[Video] Demoing SQL Server 2019’s new Accelerated Database Recovery

Publié le 4 mars 2019 sur brentozar.com
 

Wouldn’t it be nice if rollbacks just finished instantly? Wouldn’t you love for startup times to be near-zero even when SQL Server crashed just as someone in the middle of a transaction? How much would you pay for all this? (Well, I’m …

Transform your SQL Server permissions

Publié le 4 mars 2019 sur sqlservercentral.com
 

SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective …

Getting Started with Azure Data Studio

Publié le 4 mars 2019 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a cross platform query tool for SQL Server. Learn how to get started using ADS to work with your SQL Server instances.

SQL SERVER – FIX: Database Diagram Error 15517 – Cannot Execute as the Database Principal Because the Principal ‘dbo’ Does Not Exist

Publié le 4 mars 2019 sur journey to sqlauthority
 

Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, one of the developers reported below error in the database while trying to open a d …

New Objects, Columns, and Messages in SQL Server 2019 CTP 2.3

Publié le 3 mars 2019 sur brentozar.com
 

Sure, there’s official documentation on what’s new in SQL Server 2019, but Microsoft’s notorious for slipping undocumented stuff in. Sometimes these new features become officially documented in subsequent preview builds, like CTP 2.2 …

SQL Server 2019 Result Set Caching?

Publié le 3 mars 2019 sur brentozar.com
 

Friday’s new CTP 2.3 added a few new fields to sys.databases: But the highlighted one has me all tingly inside, kinda like the first time I heard Winona Ryders use the word “chainsaw” in a sentence. (Bonus points for readers who get t …

What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215

Publié le 3 mars 2019 sur journey to sqlauthority
 

Question: What is Clean Buffer in DBCC DROPCLEANBUFFERS? Answer: I must give a big credit to the guy who actually asked me this question as in my over 20 years of the journey no one has ever asked me this question. Though the answer to this q …

SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.

Publié le 2 mars 2019 sur journey to sqlauthority
 

Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Win …

Unit Testing with SQL Server

Publié le 1 mars 2019 sur sqlservercentral.com
 

Learn how to begin unit testing with tSQLt and SQL Server.

Getting Started with Power BI – Part 1

Publié le 1 mars 2019 sur sqlservercentral.com
 

In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.

Calling all Oracle Database users

Publié le 1 mars 2019 sur sqlservercentral.com
 

We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle dev …

SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

Publié le 1 mars 2019 sur journey to sqlauthority
 

Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system …


Pages :