Blog: Kenneth Fisher

210 blogs updated: 18 min. ago
Windowing without a partition by or an order by
If you've never worked with windowing functions they look something like this: The other day someone mentioned that you could ... Continue r...
21-02-2018 15:01:08 Kenneth Fisher SQL Server
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 ... Continue reading
19-02-2018 15:40:44 Kenneth Fisher SQL Server
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 ... Continue reading
15-02-2018 15:18:33 Kenneth Fisher SQL Server
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 ... Continue reading
13-02-2018 15:02:32 Kenneth Fisher SQL Server
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, ... Continue reading
07-02-2018 15:26:30 Kenneth Fisher SQL Server
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 ... Continue reading
05-02-2018 15:11:24 Kenneth Fisher SQL Server
The difference between blogging about something you know, and something you are learning (Love blogging! Live!)
Close but you need to blog about learning while blogging about the difference of blogging when you are learning something ... Continue readi...
31-01-2018 15:45:08 Kenneth Fisher SQL Server
How To: Install SQL Server on an Azure VM
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is ... Continue reading
29-01-2018 15:01:50 Kenneth Fisher SQL Server
Help it takes forever to open the SQL Server Log!
Just to be very clear, I'm talking about the SQL Server Log, not database logs. Sometimes this is called the ... Continue reading
24-01-2018 15:49:34 Kenneth Fisher SQL Server
What's dbo?
Don't you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems ... Continue reading
22-01-2018 16:17:54 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.