T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
4 reads
Blog Posts
T-SQL Documentation Generator
This post is a response to this month’s T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way...
2019-01-08
258 reads
T-SQL Documentation Generator
This post is a response to this month's T-SQL Tuesday #110 prompt by Garry Bargsley. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2019-01-08
15 reads
T-SQL Tuesday #110 – Automate All the Things
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
177 reads
T-SQL Tuesday #110 – Automate All the Things
From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...
2019-01-08
8 reads
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source...
2019-01-08
400 reads
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this...
2019-01-08
9 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Chicago on March 23rd 2018! This...
2019-01-08
3 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop...
2019-01-08
228 reads
A Monumental Migration to SQL Server 2016 - Part 1
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...
2019-01-07
5 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers