Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind...
2015-07-21
4 reads
Ed Elliott's Sql Developer Blog
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
1,418 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
120 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
82 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
215 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks...
2015-07-20
2 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
511 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
29 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on...
2015-07-17
36 reads
WaitForSql (to start)
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a...
2015-07-17
1 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