Inside an SSDT Deployment Contributor
In my deployment filter I have been asked a couple of times to allow columns that exist on a table...
2015-09-23
40 reads
Inside an SSDT Deployment Contributor
In my deployment filter I have been asked a couple of times to allow columns that exist on a table...
2015-09-23
37 reads
Deployment Contributor KeepTableColumns Filter
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know about when you create the dacpac, possibly you have...
2015-09-23
5 reads
Inside an SSDT Deployment Contributor
In my deployment filter I have been asked a couple of times to allow columns that exist on a table that do not exist in a dacpac to be...
2015-09-23
8 reads
SSC Editorial: The Counter Offer – Part 1/Part 2
Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The...
2015-09-23
598 reads
Dynamic SQL & Quotename
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
384 reads
SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...
2015-09-23
982 reads
Pratical Use of a SQL Server Database Snapshot
I was doing a database code deployment the other night and the first step in the release plan was “Take...
2015-09-29 (first published: 2015-09-23)
7,211 reads
I’m Speaking! SQL Saturday #431 – Spartanburg
As I’ve mentioned before, living in Louisville offers up great opportunities to various events within the SQL Community. This weekend...
2015-09-23
531 reads
Predicate Order is Critical
I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...
2015-09-23
50 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers