-
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
Leave a commentJuly 18, 2018 by Kenneth Fisher
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
Continue reading -
Counting NULLs
2July 16, 2018 by Kenneth Fisher
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
Continue reading -
Balancing Security Concerns.
2July 12, 2018 by Kenneth Fisher
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
Continue reading -
Code I’d Hate To Live Without: T-SQL Tuesday #104
1July 10, 2018 by Kenneth Fisher
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his …
Continue reading -
SQL Homework – July 2018 – Create a SQL Agent Job
Leave a commentJuly 2, 2018 by Kenneth Fisher
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
Continue reading -
SQL Puzzle – FizzBuzz3d
17June 27, 2018 by Kenneth Fisher
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case …
Continue reading -
Be our guest, be our guest, put our database to the test.
3June 25, 2018 by Kenneth Fisher
When I think of the public role I often think of the guest database principal (user) at the same time. …
Continue reading -
Strings vs Identifiers
3June 20, 2018 by Kenneth Fisher
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or …
Continue reading -
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
3June 18, 2018 by Kenneth Fisher
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just …
Continue reading -
The identity column, the insert and the linked server.
1June 14, 2018 by Kenneth Fisher
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
Continue reading
SQL Studies
Live, Learn, Share
