Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here's a hint: it has to deal with...
2016-12-22
7 reads
Blog Posts
Database Backups – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-22
686 reads
Quick Command Shells–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-22
609 reads
SSIS Custom Logging Levels
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
482 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this! With Windows Server 2016,...
2016-12-22
4 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,257 reads
Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...
2016-12-21
418 reads
Data gateway confusion
Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...
2016-12-21
416 reads
Optimize For Unknown
Hello Dear Reader! It's been a while. I was working with a friend and we came across an interesting problem....
2016-12-21 (first published: 2016-12-05)
3,320 reads
Power BI Custom Visuals Class (Module 30 – Linear Gauge)
In this module you will learn how to use the Linear Gauge Power BI Custom Visual. The Linear Gauge would...
2016-12-21
743 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers