Category Archives: Microsoft SQL Server
-
Read-only tables
5January 21, 2019 by Kenneth Fisher
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it …
Continue reading -
Controlling the firewall for an Azure SQL DB via T-SQL
2January 16, 2019 by Kenneth Fisher
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I …
Continue reading -
SQL Bits 2019: The Great Data Heist
Leave a commentJanuary 14, 2019 by Kenneth Fisher
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL …
Continue reading -
Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
5January 8, 2019 by Kenneth Fisher
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s …
Continue reading -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 2, 2019 by Kenneth Fisher
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
Continue reading -
Identity in a SELECT
4December 19, 2018 by Kenneth Fisher
Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
Continue reading -
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
4December 17, 2018 by Kenneth Fisher
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
Continue reading -
Bulk insert and an identity column
1December 12, 2018 by Kenneth Fisher
TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file …
Continue reading -
Moving SSISDB is not as easy as it sounds
Leave a commentDecember 10, 2018 by Kenneth Fisher
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 …
Continue reading -
SQL Homework – December 2018 – Configure SSMS
Leave a commentDecember 3, 2018 by Kenneth Fisher
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
Continue reading
SQL Studies 