Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,283 reads
The New MidnightDBA.com is live!
GUYS! GUYS! GUYS!!! We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for,...
2013-04-02
630 reads
Merging SQL Server and Softball Just for Fun
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,291 reads
SQL Server Reporiting Services: Migrating SSRS reports, data sources and subscriptions from one server to another
As part of our SQL Server infrastructure consolidation project, it was decided to consolidate multiple companies SQL Server 2005 / SQL...
2013-04-09 (first published: 2013-04-02)
8,508 reads
A Rickety Stairway to SQL Server Data Mining, Part 10.3: DMX Prediction Queries
by Steve Bolton
In the last two installments of this series of amateur self-tutorials on SQL Server Data Mining (SSDM),...
2013-04-10 (first published: 2013-04-01)
3,804 reads
April 2013 – Monthly SQL Server Checklist
After working on this monthly checklist for over a year, I’ve recently discovered that there isn’t anything that we should...
2013-04-01
549 reads
UNPIVOT a table using CROSS APPLY
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,192 reads
Last Weeks Top “Reading” Links #26
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-01
446 reads
Setup SSL Access to SSRS 2012 with Active Directory Certificate Services
The objective was to configure SSL access to a SQL 2012 Reporting Services server in Native Mode. The Certificate Issuer...
2013-04-01
12,440 reads
SQL Server Analysis Services Webinar
Join me tomorrow, April 2. 2013, at 11:00 PM EST for a free webinar which is part of an entire...
2013-04-01
866 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