Why You'll Want to Create Your Temp Tables Before Populating them
The point of this post is to cleary explain how the combination of the use of data definition language for your temporary...
2009-06-11
1,107 reads
HuggyBear
- Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
- Blog: http://dbhive.blogspot.com/
- Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor
- Website: https://ca.linkedin.com/in/intellabase
- LinkedIn: https://ca.linkedin.com/in/intellabase
TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,485 reads
Configuring Auto-Retry on SQL Server Agent
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to...
2009-05-27
7,246 reads
SQL Teach in Vancouver Coming Up Quick - Draught Presentation Ready (phew)
As Brad McGehee mentioned recently: SQLTeach (a part of the larger DevTeach event) will be held in Vancouver, BC this...
2009-05-21
1,062 reads
Workplace Discrimination in Quebec - part 2: Ignoring the Warning Signs
My Dearest Mister André Pratte,
Regarding your article in the Globe and Mail, I was quite surprised to see you run...
2009-05-21
1,589 reads
The Pro-Active DBA during the Economic Tsunami
As none of us are immune to the current financial crisis, and your development projects have probably come to a...
2009-05-16
760 reads
RE: Career Development and Training by Lynn Pettis
Thank you, Lynn, for your previous post. I have reinforced in my first blog posting on SSC about certification as...
2009-04-29
1,759 reads
Spring Still Not Really Hitting Montreal Yet, thus More Time to Hunt Down Useless Indexes
Hopefully, by the time we have our annual family vacation in May, the Cherry Blossoms will be out – until then...
2009-04-23
749 reads
LinkedIn as your Stepping Stone for Opportunities with Internationally-Oriented Organisations
As some of you may have read already, Andy Warren‘s series on LinkedIn (part 1, 2,3) and networking has sparked my...
2009-04-19
1,181 reads
SQL Server 2005/8 Database Compression Presentation in Burlington, Vermont - April 15th
Yesterday, I drove the Smart down to Burlington/Colchester, Vermont to meet up with MVP Roman Rehak and speak to the local...
2009-04-13
1,081 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers