Retiring of the MCM Certifications, Part II
Image acquired from Twitter
In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a...
2013-09-03
1,351 reads
Blog Posts
SQL – Find CPU,Memory,Connections, VLF’s,I/O of all the Databases
Find CPU, Memory, No Of Connections/databases and VLF’s and I/O details in one single script.
You just need to run the...
2013-09-03
1,648 reads
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,671 reads
SQL Server: Data File Structure
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...
2013-09-03
836 reads
SQLSat 235 Wrap-Up
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for...
2013-09-03
785 reads
SQLSat 235 Wrap-Up
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for Curacao in my queue. I had fully intended on...
2013-09-03
13 reads
When I run “Script as” it isn’t (or is) … How do I fix it?
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...
2013-09-03
778 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,779 reads
Handling Large Many to Many bridge tables
In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...
2013-09-02
3,393 reads
Make the PASS Summit Work For Your Employer
It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy...
2013-09-02 (first published: 2013-08-26)
1,964 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