Saving Grace
According to Merriam-Webster the definition of grace is:
1a : unmerited divine assistance given humans for their regeneration or sanctification; b : a...
2013-05-30
1,232 reads
SQL Swimmer
Certifiable?
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
608 reads
The Long and Winding Road
“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was...
2013-05-14
562 reads
Custom Reports for SSMS 2012
I presented on this topic at the TriadSQL User’s Group meeting on 3/26/13. I promised I would post my code/solutions,...
2013-03-29
2,145 reads
Summit 2012 is over, but not forgotten
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
723 reads
Policy-Based Management, How Sweet It Is
I have just recently changed employers and in doing so, I’ve changed my role from Data Architect to DBA/BI Developer. ...
2012-10-24
1,904 reads
PASS Election Season
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
603 reads
Mentoring
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
632 reads
Paying it Forward
My company has recently put forth an effort to hire fresh college graduates and interns. I think this is a...
2012-08-24 (first published: 2012-08-22)
1,723 reads
Replication and TFS
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...
2012-08-16
2,306 reads
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers