"An item with the same key has already been added."
In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...
2013-02-28
8,594 reads
Check out IT Central Station
If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the...
2013-02-28
1,194 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter. There were over 200 attendees! The recording of...
2013-02-28
1,630 reads
Optimizing Protected Indexes (was Indexing Encrypted Data)
Why bother encrypting?
Riddle me this batman? Why bother to Encrypt?
As a SQL Server DBA I am primarily responsible for making...
2013-02-27
1,820 reads
We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)
Your MidnightDBAs
Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting...
2013-02-27
1,273 reads
Attaching an MDF with no Log (AdventureWorks)
Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently...
2013-02-27
2,000 reads
It Is Your Fault
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my...
2013-02-27
1,532 reads
Finding SQL Server Installs Using Powershell
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,452 reads
A Month of PowerShell – Day 27 (Scripting SQL Objects)
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-11 (first published: 2013-02-27)
3,482 reads
Setting up an Internal Friendly URL
Note: This solution is not necessarily the best or most efficient solution in all cases. It is, however, very simple...
2013-02-27
3,311 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
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....
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