The Curse of Relational Databases
Let’s face it, none of Information Technology is easy. Oh yeah, there are those few geniuses that have an absolute...
2014-06-23 (first published: 2014-06-18)
5,172 reads
The Scary DBA
Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,357 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...
2014-06-13 (first published: 2014-06-10)
2,060 reads
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
751 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,361 reads
Add an Instance to SQL Server Azure Virtual Machine
How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...
2014-05-19 (first published: 2014-05-13)
1,489 reads
Carolina Cruise
I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...
2014-05-09
492 reads
Speaker of the Month, May 2014
Whoa! Another month gone by already? I guess I better pick a speaker of the month then. I went to...
2014-05-02
1,196 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,379 reads
I Am Better Than You
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why...
2014-04-22
933 reads
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers