Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse
If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...
2011-07-18
696 reads
PASS Update #60
I’ve written a lot here, but for June & July (and part of August) I’m trying to just keep the ship...
2011-07-18
653 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
18 reads
Presenting Upserts to PASS AppDev VC
Hopefully this crowd knows a little about what they're getting into! John Jakubowski (blog|twitter) has graciously asked me to present on upsert strategies with SSIS. What are "upserts"? A...
2011-07-18
10 reads
Second Chances: PASS Community Choice Sessions
Recently I found out that my PASS presentation submission ‘Policy-Based Management’ has a second chance to be accepted for the...
2011-07-18
803 reads
Denali SQLPS First Impressions
I’ve taken a few hours to try out Denali CTP 3 sqlps and noticed some welcome changes. The biggest change...
2011-07-18
2,048 reads
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,984 reads
Execute Permissions
Written by David Postlethwaite
Security of the SQL database is becoming more and more important these days yet I’m finding that...
2011-07-18
14,367 reads
SQL Server Backup – Inadvertent Striping
When I started working with SQL Server I got bit in the rear one day while I was testing backups....
2011-07-18
1,706 reads
Manic Monday......Notes from the field, Playing catchup
It's the beginning of the new work week, and as they say, it's Just Another Manic Monday....[Bangles].
I have a...
2011-07-18
1,119 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