Relational databases vs Non-relational databases
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared...
2015-08-27
1,523 reads
Blog Posts
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
628 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
357 reads
Studying for the 70-462 Exam: Database Mirroring
If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...
2015-08-27 (first published: 2015-08-18)
2,403 reads
Using Power BI with HDInsight Part 1: Power Query and Files
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-27
712 reads
Adding a VLDB database to an SQL Server Availability Group
Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...
2015-08-26 (first published: 2015-08-18)
2,100 reads
Agile Development – A DBA’s Initial Thoughts
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
629 reads
Critical Virtualized Database Education at VMworld
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any...
2015-08-26
632 reads
Nesting Aggregates with Window Functions
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....
2015-08-26 (first published: 2015-08-18)
2,616 reads
Shredding XML in XEvents
One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often...
2015-08-26
18 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers