31 Days of SSIS – SSIS Naming Conventions (31/31)
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,436 reads
Blog Posts
February Question: Share with us your “best” restore disaster stories.
As DBAs, making backups and restoring data is one of the foundational skills we all must master. But sometimes things...
2011-02-01
452 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,713 reads
PASS Update #51-Summit Site Selection
In November/December HQ requested that the Board to send in suggestions for possible sites for the 2013 PASS Summit. I...
2011-02-01
1,564 reads
SQL Rally BI Sessions
This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder...
2011-02-01
1,187 reads
This Month… SSWUG Free SSIS Expo
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
424 reads
What’s a Passive Server?
Licensing software is often a more complicated process than I think it should be. Licensing database software seems to be...
2011-02-01
5,173 reads
Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,509 reads
31 Days of SSIS – Importing Execution Plans (30/31)
31 Days of SSIS
Almost time to wrap up the 31 Days of SSIS. We are down to just two more...
2011-01-31
2,858 reads
Building an Extremely Power Efficient Intel Sandy Bridge Desktop System
Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty...
2011-01-31
2,156 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers