Monthly Archives: December 2017
-
What is impersonation for?
3December 27, 2017 by Kenneth Fisher
I was doing some research on impersonation the other day, and among other things, I ran across a forum question …
Continue reading -
Making music with Powershell
5December 20, 2017 by Kenneth Fisher
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing …
Continue reading -
When do usernames and passwords belong in connection strings
Leave a commentDecember 18, 2017 by Kenneth Fisher
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your …
Continue reading -
How to: Create an Azure VM with SQL Server using a default template
1December 14, 2017 by Kenneth Fisher
One of the really cool things about the cloud is how quickly you can spin up a new machine to …
Continue reading -
T-SQL Tuesday #97 – Setting learning goals for 2018
3December 12, 2017 by Kenneth Fisher
T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic …
Continue reading -
Restrict the usage of a SQL Server Authenticated Application Id
1December 6, 2017 by Kenneth Fisher
SQL Server login ids may not be the most secure thing in the world but they are likely to be …
Continue reading -
SQL Homework – December 2017 – View the log
3December 4, 2017 by Kenneth Fisher
Last homework of the year. Last month was to create a view. This month it’s time to take a look …
Continue reading
SQL Studies 