Re-blog – July 29-August 4
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-05
569 reads
Audit SQL Logins
Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...
2011-08-05
4,779 reads
PowerPivot – Perspectives
PowerPivot – Perspectives
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split...
2011-08-05
4,424 reads
Celebrating Mistakes-Part 2
I’ve been thinking about this a lot. It’s easy to say we want to take risks, much harder to set...
2011-08-05
1,009 reads
Two New TPC-E Submissions
Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three...
2011-08-05
986 reads
The Best Part of My New Job
The Best Part of My New Job
Come to the Dark Side, We have Nutter Butters
If you had told me a...
2011-08-04
914 reads
Celebrating Mistakes-Part 1
Most of us learn more from mistakes than successes. We talk about taking risks, but what is the average response...
2011-08-04
676 reads
MSSQLTips.com Kindle Contest
I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...
2011-08-04
1,047 reads
My SQLbits sessions
Since today its official, I'm presenting 2 sessions at the SQLbits conference in Liverpool
(http://www.sqlbits.com) from September 30 –
October 1. Here...
2011-08-03
864 reads
SQL Server 2011 “Denali”: Get T-SQL query metadata without executing it
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...
2011-08-03
1,024 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