Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from...
2013-01-15
563 reads
Sam Vanga
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from...
2013-01-15
508 reads
Every ebook from Apress for $15
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
988 reads
PASS SQL Saturday World Map
I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday...
2012-11-20
1,006 reads
PASS Summit 2012 Twitter Dashboard
As a business intelligence developer, my skills include taking the raw data, shaking it to remove all the junk, and...
2012-11-12
1,547 reads
Create Several Shell SSIS Packages In Minutes Using BIML
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,669 reads
I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
691 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,528 reads
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,789 reads
SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,267 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers