Category Archives: SQLServerPedia Syndication
-
What’s dbo?
6January 22, 2018 by Kenneth Fisher
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading -
Fun with sp_rename
Leave a commentJanuary 11, 2018 by Kenneth Fisher
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
Continue reading -
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
Leave a commentJanuary 9, 2018 by Kenneth Fisher
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
Continue reading -
SQL Homework – January 2018 – Inspect an Execution Plan
6January 3, 2018 by Kenneth Fisher
It’s a new year and yet education never ends. So this month let’s take a look at an important part …
Continue reading -
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
SQL Studies 