Overview of Azure SQL Database Networking
The post Overview of Azure SQL Database Networking appeared first on SQLServerCentral.
Voting Open for #SQLBits Sessions, and Here’s My Oddball Idea
Voting is open now for SQLBits sessions, and I have to warn you that there are a LOT of sessions to choose from. Bits doesn’t just flat out take the top vote-getting sessions – they use votes as part of the session selection factor – …
Wait statistics workshop at SQLBits in London 2020 – finally!
We’re coming to SQLBits finally! Both Kimberly and I will be there for the first time in London in March/April – at long last the dates work for us – plus Erin will be there again too. The training day schedule for the conference …
SQL SERVER – Parameter Sniffing Simplest Example
Today we will see a very simple example of the Parameter Sniffing. I was asked by my client if I can explain to them what is the simplest example of the parameter sniffing during a recent consulting engagement of Comprehensive Database Performance Heal …
Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking
The post Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking appeared first on SQLServerCentral.
Memory-Optimized TempDB Metadata in SQL Server 2019
The post Memory-Optimized TempDB Metadata in SQL Server 2019 appeared first on SQLServerCentral.
Finding Non Current Cumulative Updates
Recently, I needed to test an older CU and couldn’t find it. At least not easily. Previously I had just searched for the update and usually quickly found it, but some of the changes on the Microsoft sites have made this harder. This is a short article …
Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key
The series so far: Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key A subset of related tables in a relational schema can satisfy any number of queries known and unknown at design time. Refactoring …
The Two Ways to Fix Non-Sargable Queries
In the database world, when we say something isn’t sargable, what we mean is that SQL Server is having a tough time with your Search ARGuments. What a sargable query looks like In a perfect world, when you search for something, SQL Server can do …
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
Sometimes it is critical to get back to basics when working on solving a complex problem at Comprehensive Database Performance Health Check. Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the s …
A Beginner’s Guide to SQL String Functions
The post A Beginner’s Guide to SQL String Functions appeared first on SQLServerCentral.
SQL SERVER – Copy Database Without Statistics Query Store
I love the follow-up questions as they demonstrate that my blog posts are read and help everything think of their own environment. Here is the follow-up question I have received to my earlier blog post about Clone Database Using DBCC CLONEDATABASE. Thi …
Test data provisioning for development – free whitepaper
The post Test data provisioning for development – free whitepaper appeared first on SQLServerCentral.
Update only Year, Month or Day in a SQL Server Date
The post Update only Year, Month or Day in a SQL Server Date appeared first on SQLServerCentral.
Monitor Current Analysis Services Activity
Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any loc …