Blog: Kenneth Fisher

208 blogs updated: 77 min. ago
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run ... Continue reading
21-06-2017 15:37:37 Kenneth Fisher SQL Server
Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He ... Continue reading
19-06-2017 16:09:56 Kenneth Fisher SQL Server
Turning ANSI_PADDING off, and why you shouldn't
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column ... Continue reading
15-06-2017 15:08:06 Kenneth Fisher SQL Server
Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he'd like to talk about DEVOPS. ... Continue reading
13-06-2017 15:16:22 Kenneth Fisher SQL Server
If you've worked much with named instances you've probably had to deal with the question "What port is that instance ... Continue reading
07-06-2017 16:01:55 Kenneth Fisher SQL Server
Backup to NUL
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In ... Continue reading
05-06-2017 16:16:33 Kenneth Fisher SQL Server
SQL Crossword
I thought I'd do another crossword. Enjoy! If you need any help with it feel free to let me know ... Continue reading
31-05-2017 15:22:19 Kenneth Fisher SQL Server
Running multiple queries at the same time.
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at ... Continue reading
24-05-2017 15:47:32 Kenneth Fisher SQL Server
What's in a partition?
In my last post on partitioning I used the $Partition command in passing. I've been thinking it deserves a bit ... Continue reading
22-05-2017 15:28:10 Kenneth Fisher SQL Server
T-SQL FizzBuzz
I was looking around for something to write about this evening and came across one of Russ Thomas' (b/t) old ... Continue reading
17-05-2017 15:02:17 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.