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
19 reads
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
228 reads
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
6,026 reads
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,416 reads
In writing some sample demos around LOB and Row-Overflow data I found a couple of oddities in the way reads...
2019-02-20
158 reads
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
318 reads
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
343 reads
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across...
2019-02-20
194 reads
We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April...
2019-02-20
773 reads
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
187 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers