Upcoming Presentations: #24HOP & #SQLSAT46
Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...
2010-08-30
767 reads
Blog Posts
Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
613 reads
MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
479 reads
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,391 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
493 reads
Jax Code Camp - My Presentation and Projects
First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...
2010-08-28
427 reads
Microsoft Offers New Certification Exam Discount
If you are intending to take any Microsoft Certification tests soon, you are in luck, because Microsoft has recently introduced...
2010-08-28
1,286 reads
Connectify
It’s a wired world. You’d think by this point, most major hotels, at least those costing upwards of $100/night, would...
2010-08-27
1,047 reads
Free SQL Server Training for the Week of August 30, 2010
The only scheduled event among the sources I have listed is the one for SQL Lunch, so it looks to...
2010-08-27
599 reads
Furniture Grade PVC – What Will You Make?
Ran across this in my weekly browsing, Formufit sells furniture grade PVC. I think I’m not quite clear on the...
2010-08-27
1,167 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