-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: February 2018

A day in the life of a Sr DBA/Dev

If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points in your career (if not quite daily).

There’s a bug in my code,
Dear Liza, dear Liza,
There’s a bug in my code,
Dear Liza, a bug.

So fix it, Read more

0 comments, 214 reads

Posted in SQLStudies on 28 February 2018

Double hop error when using SQLCMD

tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.

One of the problems with linked servers (no rude noises please) is that frequently you will see a double hop error.

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

Let’s start with a brief explanation of a double hop. If… Read more

2 comments, 720 reads

Posted in SQLStudies on 26 February 2018

Windowing without a partition by or an order by

If you’ve never worked with windowing functions they look something like this:

SELECT name, max(create_date) OVER 
		-- No this isn't meant to make sense
		(PARTITION BY lower(left(name,1)) ORDER BY owner_sid)
FROM sys.databases;

The other day someone mentioned that you could use ROW_NUMBER which requires the OVER clause without either the… Read more

2 comments, 1,302 reads

Posted in SQLStudies on 21 February 2018

The default filegroup, and why you should care.

You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index & heaps) and another for the indexes (non-clustered indexes). Or maybe you want to separate your data tables from the system tables. There are any number of reasons why you… Read more

2 comments, 206 reads

Posted in SQLStudies on 19 February 2018

Synonyms, how and why.

Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even though it’s been around for >10 years (SQL 2005). In fact, I’d be willing to bet that a good chunk of the people reading this have never (or just… Read more

6 comments, 3,134 reads

Posted in SQLStudies on 15 February 2018

Hobbies, stress relief, and meeting management: T-SQL Tuesday #99


It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that means that Adam Machanic’s (b/t) brainchild has been running for over 8 years! This month is hosted by none other than Aaron Bertrand (b/ Read more

2 comments, 1,878 reads

Posted in SQLStudies on 13 February 2018

Backups of backups or How long is my backup really available?

I’ve said before that backups are at once one of the easiest things DBAs do, one of the most important, and one of the most complicated. Take a full backup, restore it. Pretty simple right? And yet it’s vital when accident or corruption require recovering data. And as simple as… Read more

1 comments, 1,696 reads

Posted in SQLStudies on 7 February 2018

SQL Homework – February 2018 – Work with security

This month let’s create some security!

  • Create logins: GUI 5 pts/Script 5 pts
    Create a SQL login and a Windows authenticated login. Make sure you can connect to the instance with each. It’s best if you understand the difference.
  • Create users: GUI 5 pts/Script 5 pts
    In a user database…

Read more

0 comments, 218 reads

Posted in SQLStudies on 5 February 2018