Blog: Kenneth Fisher

219 blogs updated: 44 min. ago
Read-only tables
Sometimes you need a table that is read only. You don't want anyone to be able to write to it ... Continue reading
21-01-2019 15:12:40 Kenneth Fisher SQL Server
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I ... Continue reading
16-01-2019 15:19:49 Kenneth Fisher SQL Server
SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It's February 27th to March 2nd. SQL Bits is one of the most popular SQL ... Continue reading
14-01-2019 15:56:55 Kenneth Fisher SQL Server
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it's taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be ... Continue reading
10-01-2019 16:10:45 Kenneth Fisher SQL Server
Automation starts by doing something once, very very carefully: T-SQL Tuesday #110
After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it's ... Continue reading
08-01-2019 15:59:24 Kenneth Fisher SQL Server
SQL Homework – January 2019 – Baselines
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years ... Continue reading
02-01-2019 15:47:10 Kenneth Fisher SQL Server
Using Microsoft Learn
I've just signed up on Microsoft's new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows ... C...
31-12-2018 15:38:51 Kenneth Fisher SQL Server
Identity in a SELECT
Always be learning right? So when I saw this I had to go HU?! That's new. What's going on here? ... Continue reading
19-12-2018 15:58:15 Kenneth Fisher SQL Server
Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error ... Continue reading
17-12-2018 15:20:59 Kenneth Fisher SQL Server
Bulk insert and an identity column
TL;DR; BULK INSERT doesn't have an easy way to specify a column list so the columns in the insert file ... Continue reading
12-12-2018 15:48:58 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.