Variables and Expressions with Connections in SSIS
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,517 reads
Moving the SQL replication snapshot folder
I recently addressed an issue where a client server's data volume was getting dangerously tight on free space. It contained...
2011-09-02
4,386 reads
SQL Server test data generation testing tools
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
949 reads
Don’t Be This Guy
Note: This post was originally posted on October 29, 2009. In the interest of the upcoming conference season, I’m republishing...
2011-09-02
713 reads
Don’t Be This Guy
Note: This post was originally posted on October 29, 2009. In the interest of the upcoming conference season, I’m republishing...
2011-09-02
820 reads
September Question: Tell us about your DBA interview experiences: good and bad.
I have only interviewed for a handful DBA jobs over the years, but they have ranged all the way from...
2011-09-01
653 reads
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
444 reads
Geekbench 2.2 Released
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
946 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
9 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
600 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