SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,953 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
551 reads
Announcing the upcoming Colorado GiveCamp
What is a GiveCamp?
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...
2011-08-16
522 reads
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,399 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers