Category Archives: SQLServerPedia Syndication
-
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 -
Using Microsoft Learn
3December 31, 2018 by Kenneth Fisher
I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows …
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 -
UDL files and connection strings
2December 5, 2018 by Kenneth Fisher
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and …
Continue reading -
Oh Query, Query, Query
1November 28, 2018 by Kenneth Fisher
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week. …
Continue reading -
My backup script (where, how, how big, etc.)
5November 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 -
The Cloud and Shadow IT.
2November 21, 2018 by Kenneth Fisher
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck. …
Continue reading
SQL Studies 