Memory grants 7: DISTINCT (Distinct Sort)
The series is alive! It’s been a while since I last talked about memory grants. Don’t worry, I still care...
2019-02-21
407 reads
Azure SQL Database Online Columnstore Unicorn and Rainbow Theory
As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without...
2019-02-21
188 reads
Webinar: Migrating SQL Server Integration Services to the Cloud
I will be doing a webinar for MSSQLTips.com about migrating your on-premises SSIS solutions to the Azure cloud. Specifically, the Azure-SSIS integration runtime environment in Azure Data Facture. The...
2019-02-21
22 reads
Appearance: SQL Data Partners Podcast #161
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
18 reads
I’ve added data classifications. Now what?
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,550 reads
Using the Sequence Object to Generate Reference Numbers
The SEQUENCE object was added to T-SQL in SQL Server 2012. It’s reasonably well known to DBAs, but less so...
2019-03-12 (first published: 2019-02-20)
4,303 reads
Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
351 reads
Query Store Central Repository – Part 1
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across...
2019-02-20
204 reads
Azure Key Vault Logging
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
238 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you do for community, whether it be volunteering, organizing, speaking,...
2019-02-20
11 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers