How to resolve ‘Login failed for user’ and sa password lost (Error 18456)
This blog post explains how to get into SQL Server if you have lost your sa password or you have...
2019-03-11 (first published: 2019-02-23)
2,965 reads
Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
280 reads
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
261 reads
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
976 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
198 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
242 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
269 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,202 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
210 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
253 reads
Blogs
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to...
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or...
Forums
Help with a stored procedure
I have a table "Mytable" containing a list of IDs. There is a web...
Need to perform leaf level aggregation
So I have a DW with a table with some pre-aggregated scores (not my...
Migrating from (mostly) 2K8 to 2016
HI all, About to start this project and would be grateful for any good...
Ask SSC