Exam Prep 70-463: Data Flow Source Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-01-19
887 reads
Understand the True Source of Problems
There’s an old joke that goes, “Doctor, doctor, it hurts when I do this.” While the person in question swings...
2015-01-19
777 reads
Except and Intersect
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,658 reads
Attending and Speaking at SQLBits XIV
The SQLBits conference has a special place in my heart – as I have written before, the previous edition of SQLBits...
2015-01-18
665 reads
SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,465 reads
Hangout with Boris Hristov
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
604 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete. Updating database (Complete) Successfully published database.
This happens everytime...
2015-01-16
29 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete....
2015-01-16
60 reads
Why does SqlPackage keep dropping and recreating constraints?
I sometimes see this when deploying via sqlpackager.exe:
Analyzing deployment plan (Complete) Updating database (Start) Dropping DF_XXX... Creating DF_XXX... Update complete....
2015-01-16
173 reads
Technology Advances – mSATA external case
I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...
2015-01-23 (first published: 2015-01-16)
6,621 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers