Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time...
2013-08-08
968 reads
Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
553 reads
How are COALESCE and ISNULL different?
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...
2013-08-16 (first published: 2013-08-07)
8,902 reads
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
856 reads
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
6,062 reads
Be Cautious When Critizing About Guidance
I recently posted some comments about some guidance offered by Microsoft when talking about the CXPACKET wait type. Nothing I...
2013-08-07
680 reads
Workload Tuning: Finding Top Offenders in SQL Server 2012
I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...
2013-08-15 (first published: 2013-08-07)
2,582 reads
24 Hours of PASS Streaming Available
If you missed the 24 Hours of PASS Summit 2013 Preview, you missed some excellent sessions. I watched a few,...
2013-08-13 (first published: 2013-08-07)
1,241 reads
Using Parameters in Power Query Extracts
Introduction
By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...
2013-08-14 (first published: 2013-08-07)
5,075 reads
SQLSaturday Numbers For Period Ending June 30, 2013
Just saw this in the PASS Connector:
The SQLSaturday numbers are in for our fiscal year, which ended June 30, with...
2013-08-07
654 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers