9003 is a Scary Number
My last post talked about 9002 errors and how they *might* be corruption.
Recently I moved up to the next consecutive...
2017-06-21
2,001 reads
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
660 reads
Back at SQL Saturday Louisville and Indy
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch...
2017-06-21
18 reads
Using OPENROWSET in SQL Server on Linux
I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the...
2017-06-30 (first published: 2017-06-21)
2,942 reads
Persisting data in docker containers – Part One
Normally when I work with SQL instances within containers I treat them as throw-away objects. Any modifications that I make...
2017-06-29 (first published: 2017-06-21)
1,831 reads
Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016
In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...
2017-06-29 (first published: 2017-06-21)
913 reads
dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers...
2017-06-21
911 reads
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest...
2017-06-20
787 reads
SQLpassion Online Trainings in July 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-06-20
179 reads
5 Business Problems You Can Solve With Temporal Tables
Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...
2017-06-20
28 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers