Blog: Kenneth Fisher


210 blogs updated: 49 min. ago
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
Recently someone mentioned the LOADHISTORY option of RESTORE. It's not horribly hard to find in BOL but it wasn't the ... Continue reading
0
18-07-2018 16:04:31 Kenneth Fisher SQL Server
Counting NULLs
Recently I was doing one of Kendra Little's (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As ... Continue reading
0
16-07-2018 15:48:58 Kenneth Fisher SQL Server
Balancing Security Concerns.
I have a presentation I do every now again on security basics that I'm actually quite proud of. One of ... Continue reading
3
12-07-2018 15:45:35 Kenneth Fisher SQL Server
Code I'd Hate To Live Without: T-SQL Tuesday #104
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
3
10-07-2018 16:20:19 Kenneth Fisher SQL Server
SQL Homework – July 2018 – Create a SQL Agent Job
For this month's homework let's try something a bit different. SQL Agent jobs are a very powerful tool frequently used ... Continue reading
4
02-07-2018 15:10:17 Kenneth Fisher SQL Server
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case ... Continue reading
4
27-06-2018 16:14:54 Kenneth Fisher SQL Server
Be our guest, be our guest, put our database to the test.
When I think of the public role I often think of the guest database principal (user) at the same time. ... Continue reading
3
25-06-2018 15:30:34 Kenneth Fisher SQL Server
Strings vs Identifiers
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or ... Continue reading
0
20-06-2018 15:05:37 Kenneth Fisher SQL Server
Misleading errors: "Server is configured for Windows authentication only." But it's not!
In general, the errors SQL gives are highly useful. Of course every now and again you get one that's just ... Continue reading
0
18-06-2018 15:01:46 Kenneth Fisher SQL Server
The identity column, the insert and the linked server.
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted ... Continue reading
0
14-06-2018 16:17:48 Kenneth Fisher SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.