Sites anglophones


How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216

Publié le 10 mars 2019 sur journey to sqlauthority
 

Question: How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? Answer: the other day, I was asked this question when someone wanted to sign up for my Comprehensive Database Performance Health Check. I indeed thought it was a …

SQL SERVER – Default Worker Threads Per Number of CPUs

Publié le 9 mars 2019 sur journey to sqlauthority
 

During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads for their machine. This is a good question. Microsoft has already answered this question so we wi …

In Azure SQL DB, what does “The connection is broken and recovery is not possible” mean?

Publié le 8 mars 2019 sur brentozar.com
 

All it really means is, “Click Execute again, and you will be fine.” If I had a dollar for every time I saw this error message in SQL Server Management Studio: The connection is broken and recovery is not possible. The error says: The conne …

Benefits of Data Masking highlighted in Gartner’s 2018 Market Guide

Publié le 8 mars 2019 sur sqlservercentral.com
 

Gartner released their 2018 Market Guide for Data Masking, providing an in-depth analysis of the market with recommendations and representative vendors – including Redgate. Gartner says that « Test data (or copy data) virtualization is a technolog …

SQL SERVER – #SQLBits 2019 Videos Are Live

Publié le 8 mars 2019 sur journey to sqlauthority
 

One of my favorite events is #SQLBits and this year it took place in Manchester. I really enjoyed being there as I had an opportunity to present one Preconference (a day-long training day) and 2 breaks out sessions. SQLBits is an amazing conference as …

Are nulls stored in a nonclustered index?

Publié le 7 mars 2019 sur brentozar.com
 

When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it:CREATE TABLE dbo.Employees ( ID INT IDENTITY(1, 1) PRIMARY KEY …

Back to Basics; Masking Address Data

Publié le 7 mars 2019 sur sqlservercentral.com
 

Protecting Personable Identifiable Information is central to the compliance of numerous regulations which your organization may be subject to. In this article Grant Fritchey starts with the basics of obfuscating address data with the data masking techn …

Introducing SQL+ Dot Net

Publié le 7 mars 2019 sur sqlservercentral.com
 

SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.

SQL SERVER – Unable to Set Cloud Witness. Error: An Existing Connection Was Forcibly Closed by The Remote Host

Publié le 7 mars 2019 sur journey to sqlauthority
 

After finishing my lab and testing, I went to my client and they showed me error while setting up cloud witness. They showed me a different error then earlier. In this blog, we would learn about fixing error Unable to read data from the transport conne …

The Curious Case of… faster disks causing more WRITELOG waits

Publié le 6 mars 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Glenn’s Tech Insights for March 6, 2019

Publié le 6 mars 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally relevant for S …

Introduction to SQL for Cosmos DB

Publié le 6 mars 2019 sur simple-talk.com
 

One of the interpretations of the term NoSQL is “Not Only SQL.” Whether this is a factual statement, or an aloof remark is open to debate. However, no one can deny that more and more non-relational data sources are being used in a range of …

What sessions do you want to see at GroupBy next month?

Publié le 6 mars 2019 sur brentozar.com
 

GroupBy.org is a free online conference run by the community, for the community. You get to pick the sessions by voting. Voting is open now through March 15 for the next event, happening April 11. Here are some of the sessions you can choose from: Just …

One-way and Two-way Tabulation Example in SQL Server – Part 2

Publié le 6 mars 2019 sur sqlservercentral.com
 

In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.

SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?

Publié le 6 mars 2019 sur journey to sqlauthority
 

Just last week, I had to present at SQLBits in Manchester, UK and I used Docker Containers for my SQL Server Presentations. I am an experienced presenter and I usually practice multiple times before I get on the stage to present on any subject. However …


Pages :