I dont use the Visual Studio SSDT Publish
I see questions pretty regularly on stack overflow and the ssdt msdn forum that is some variation on “I am doing a publish through visual studio and it doesn't...
2015-08-19
4 reads
Ed Elliott's Sql Developer Blog
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
695 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
38 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
39 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 2008. The 2012 project referenced the 2008 project as...
2015-08-17
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-21 (first published: 2015-08-17)
1,957 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
32 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
26 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
3 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,589 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers