Category Archives: Microsoft SQL Server
-
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 -
My backup script (where, how, how big, etc.)
4November 26, 2018 by Kenneth Fisher
A while back I wrote about how to find where your backups are. And I’ve also written about I use …
Continue reading -
Dealing with multiple AD accounts
7November 19, 2018 by Kenneth Fisher
To help promote the seperation of duties one of the things my company has done is to divide our permissions …
Continue reading -
Parameterized dynamic SQL is parameterized.
3November 15, 2018 by Kenneth Fisher
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic …
Continue reading -
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
5November 13, 2018 by Kenneth Fisher
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a …
Continue reading
