Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,811 reads
Convert EBCDIC to ASCII in SSIS
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,738 reads
Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...
2011-08-31
2,530 reads
SQL Server, EarthQuakes and the End…Of DBAs?
SQL Server, EarthQuakes and the End…Of DBAs?
What does the advent and integration of VMs, SSDs, and the Cloud mean for...
2011-08-31
2,594 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,420 reads
Mobile Commerce and SQL Performance Tuning
I was reading through Gartners Top Predictions and one prediction captured my attention:
“By 2014, over 3 billion of the world's...
2011-08-31
1,738 reads
Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...
2011-08-31
2,201 reads
Computed Columns and UDFs
I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a...
2011-08-30
3,414 reads
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,403 reads
Strong Manager or Weak Manager?
Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...
2011-08-30
1,723 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