Authentication considerations for your applications when migrating to Azure SQL Managed Instances
This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...
2019-01-29
328 reads
The Hybrid DBA's Blog
Azure SQL Managed Instance – full blown SQL Server in the cloud….?
This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...
2019-01-29
1,161 reads
Some of my goals for 2019
In late December 2018 I had a discussion with Amanda Martin the PASS Community Manager around things that I would...
2019-01-03
203 reads
Adding a database running in a docker container to SQLTest
in my previous post I wrote about how easy it is to add the tSQLt unit test framework to your...
2018-12-29
432 reads
How to use tSQLt unit test framework with a SQL Server database in a docker container
This blog post describes how to add the tSQLt unit testing framework to a database running in a docker container....
2018-12-29
1,426 reads
How to install the tSQLt unit test framework to start unit testing your database code
This blog post describes how easy it is to install the tSQLt framework.
Don’t know much about tSQLt? If you are...
2018-12-29
494 reads
SQL Server services will not start automatically after server reboots
This blog post is about a situation where after windows patching the SQL Server service and SQL Server Agent services...
2018-12-17
271 reads
Setting up CentOS to run docker for SQL Server
This blog post is about running SQL Server in a docker container on CentOS Linux distribution.
This was both an experiment...
2018-12-13
280 reads
This is a company that practises what they preach
How good is a company at engaging with their user base? Obviously when things are going great then it’s wins...
2018-10-22
951 reads
Connecting to SQL Server 2017 using Visual Studio 2017 and getting “An incompatible SQL Server version detected”
This blog post details the error you may get when using Visual Studio 2017 and you get errors that you...
2018-10-24 (first published: 2018-10-13)
1,918 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
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...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
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