Being an Exceptional DBA Award 2011 Finalist
On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...
2011-07-25
845 reads
Using SMO Transfer Class to Script Database Objects
I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script...
2011-07-25
5,005 reads
Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing
There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the...
2011-07-24
1,748 reads
South Florida IT Camp Presentation
Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:
2011-07-24
615 reads
Lookup functions in SSRS 2008 R2 - I
Introduction
Most of us who are regularly working with SSRS have always felt the need of some way through which multiple...
2011-07-22
35,034 reads
SQLSaturday Orlando 2011 Call For Speakers Closes July 24
The 2011 version of SQLSaturday Orlando (officially SQLSaturday #85), a joint effort between Orlando's PASS chapters OPASS and MagicPASS, is...
2011-07-22
591 reads
I’ve Got A “SQLSat” In Kalamazoo
Last night I received an e-mail letting me know that I’ll be presenting at SQL Saturday #84 in Kalamazoo, MI. ...
2011-07-22
537 reads
Dynamically generate current Year, Month or Date member with MDX
MDX can be extended with Visual Basic functions like the FORMAT() and NOW() functions to dynamically generate the current year, month or...
2011-07-22
2,551 reads
Visual Studio vNext
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
730 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,263 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