The Basic Security Model in SQL Server – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-29
3,463 reads
SSIS For Each Loop over files with Date in Name
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
10,577 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for...
2011-08-29
63 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for...
2011-08-29
1,108 reads
Notes From The 2011 Jacksonville Code Camp
In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a...
2011-08-29
833 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
831 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
922 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things...
2011-08-29
7,080 reads
Code Camp New Zealand 2011
I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It...
2011-08-29
933 reads
SQL Server Hardware Choices Made Easy
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a...
2011-08-29
1,970 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