Excluding Schemas in SQL Compare
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,423 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
2012-08-08 (first published: 2012-08-02)
3,335 reads
Creating a DDL Trigger
One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...
2012-08-07 (first published: 2012-07-31)
2,771 reads
Removing a DDL Trigger
In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...
2012-08-07
949 reads
Identity Insert and Table Variables – CONNECT issue
I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))
INSERT...
2012-08-03
2,752 reads
Who’s Responsible
This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...
2012-08-03
893 reads
Forty Five Minutes
Excellent: Dilbert on data analysts
The best part is the last quote: I like how you punctuate your ignorance with certainty.
Filed...
2012-08-01
1,041 reads
Password Resets
I read this piece from Troy Hunt, which is a long look at the password reset process for a web...
2012-07-31
1,679 reads
#GetHawt – The Summer 2012 Edition
Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...
2012-07-30
1,751 reads
Working at Home Tips for Erin
A friend of mine, Erin Stellato (blog | @erinstellato) is about to change jobs. She’ll go from working in an office...
2012-07-26 (first published: 2012-07-23)
2,574 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