Building a Database DevOps Process at the Data Platform Summit 2017
I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to...
2017-03-21
673 reads
Blog Posts
C#'s foreach ruined my afternoon
The other afternoon I ran into some nightmarish debugging with the following code:
private static void StartThreads()
{
var values = new List<int>() { 1, 2, 3 };
...
2017-03-21
10 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,740 reads
DBA 101: Unique Constraint vs Unique Index
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,566 reads
Here I go again
About two years ago I wrote my first blog post.
About a year ago I paused my blogging activity. That’s when...
2017-03-21
302 reads
SSIS Articles on SQLShack
Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project...
2017-03-21
1,078 reads
The Pen Cap
This post is for all you up and coming data professionals out there. Over the course of the last week...
2017-03-21
496 reads
UK Budget 2017 – The Death Knell for Small Business?
Well I suspect not however I suspect it will likely have a major impact. What has this got to do...
2017-03-21
517 reads
Using Azure CLI to do stuff….
For this post I am going to talk about one of the methods I use to manage my Azure resources.
The...
2017-03-21
331 reads
Backup and Restore Strategies in SQL Server : A Brief Introduction
Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has...
2017-03-20
6 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers