SSRS R2 - Naming Excel Worksheet Tabs
I was recently asked if it was possible to name an excel tab based on a page in a reporting...
2010-06-21
2,708 reads
Blog Posts
T-SQL - Finding Changes
Someone posted a note recently asking about how to detect the changes in a sequence. Say you have a table...
2010-06-21
4,135 reads
Live Meeting Presentation – ETL with PowerShell
On Tuesday June 22nd 9 PM Eastern I”m presenting ETL with PowerShell for PASS AppDev VC—a virtual chapter of Professional...
2010-06-20
1,026 reads
SQL Server MasterClass Event Review
I often begrudge a 5am start to travel anywhere, let alone to SQL events but this was a trip definitely...
2010-06-19
518 reads
3.15Kw Grid-Tied Solar PV System Online
I took a day off work so I could be here when Namaste Solar and IREA came out to my...
2010-06-18
868 reads
Building a PASS Voting Solution – Part 2
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
748 reads
Finding Duplicates
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,112 reads
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,943 reads
June SCSUG Meeting Follow-up
This is a bit later than usual as the meeting was a week ago now, but I wanted to post...
2010-06-18
661 reads
Learn SQL Server 2008 R2 with 24-HOP
Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for...
2010-06-18
409 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers