Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one 2008. The 2012 project referenced the 2008 project as...
2015-08-17
12 reads
Ed Elliott
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
722 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
43 reads
Ignore a warning on a dacpac reference at your peril
I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...
2015-08-17
47 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of ram and a few hundred megabytes of hard disk...
2015-08-17
14 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
31 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
36 reads
AdventureworksCI Step 5 Adding tSQLt to the solution
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-31 (first published: 2015-07-22)
1,612 reads
AdventureworksCI Step 4 Pushing to GitHub
This is part of a series on how to take the Adventureworks database and bring it in line with modern...
2015-07-29 (first published: 2015-07-22)
1,785 reads
Is It Worth Writing Unit Tests?
What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.
2015-07-23
8,719 reads
Blogs
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...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers