Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....
2011-08-16
794 reads
Calculate table size with existing data
Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...
2011-08-16
1,012 reads
T-SQL Enhancements: OVER clause
With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of...
2011-08-16
1,459 reads
SQL MCM Training – Day 8
Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...
2011-08-16
752 reads
MCM Training – Day 6 & 7
My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...
2011-08-15
547 reads
When Do You Take a Full Backup?
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-15
781 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,400 reads
Using SSIS lookup transformation editor with millions of rows
If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...
2011-08-15
12,376 reads
I am a Big Bro
The first time I did any volunteering work for PASS was last year at the Summit. I enjoyed doing it....
2011-08-15
1,674 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send...
2011-08-15
24 reads
Blogs
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...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
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...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
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