SQL Server Corruption - Bring Order Out Of Chaos
I wanted to document a couple of important tasks you should be doing as part of your SQL Server maintenance/backup...
2018-05-12
59 reads
Day 12 INFORMATION_SCHEMA database
Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because...
2018-05-12
288 reads
Day 11 MySQL System Database
Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are...
2018-05-11
229 reads
Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-05-11
903 reads
YouTube Channel Update: 11 May 2018
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
232 reads
Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data...
2018-05-11
262 reads
Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data...
2018-05-11
821 reads
SQL Server Database Snapshots
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
2,275 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
129 reads
DMV To List Foreign Keys With No Index
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,575 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