Category Archives: SQLServerPedia Syndication
-
Double hop error when using SQLCMD
2February 26, 2018 by Kenneth Fisher
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
Continue reading -
Windowing without a partition by or an order by
4February 21, 2018 by Kenneth Fisher
If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
Continue reading -
Synonyms, how and why.
8February 15, 2018 by Kenneth Fisher
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
Continue reading -
Hobbies, stress relief, and meeting management: T-SQL Tuesday #99
2February 13, 2018 by Kenneth Fisher
It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that …
Continue reading -
Backups of backups or How long is my backup really available?
1February 7, 2018 by Kenneth Fisher
I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, …
Continue reading -
SQL Homework – February 2018 – Work with security
1February 5, 2018 by Kenneth Fisher
This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
Continue reading -
The difference between blogging about something you know, and something you are learning (Love blogging! Live!)
4January 31, 2018 by Kenneth Fisher
Close but you need to blog about learning while blogging about the difference of blogging when you are learning something …
Continue reading -
How To: Install SQL Server on an Azure VM
3January 29, 2018 by Kenneth Fisher
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading
SQL Studies 