Pro SQL Server 2012 Practices Chapter 18 Review Tuning for Peak Load
I'm on a Book!
Hello Dear Reader, early last year I was asked if I would like to contribute to a...
2013-01-22
905 reads
SQLBalls
How Do You Query Maintenance Plan Package Metadata?
Hello Dear Reader! Since I’ve joined Pragmatic Works I’ve learned a lot, seen a lot, and assisted in interviewing a...
2013-01-23 (first published: 2013-01-21)
5,023 reads
Pro SQL Server 2012 Practices
Hello Dear Reader. Every now and then professionally you get to be a part of something really cool. Back in...
2013-01-15
802 reads
Dude Where Did my AD Account Go? Troubleshooting Duplicate SID's.
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,463 reads
SQL Live 360 Kicks off Today!
Hello Dear Reader! Today in beautiful Orlando FL at the Loews Royal Pacific Resort the Live 360 Conferencekicks off. Live...
2012-12-11
881 reads
PASS Summit Page & Row Compression Deep Dive
Hello Dear Reader! Today is the Big day for me here at the PASS Summit 2012. I'll be presenting the...
2012-11-09
909 reads
SQL PASS Summit 2012 Keynote Day 1
Hello Dear Reader! I'm sitting in the Keynote now writting up a summary of the event. More to come!
2012-11-07
580 reads
DBA Question of the Day: Statistic
http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...
2012-10-26
1,063 reads
DBA Question of the Day
When I used to work in an office I had a stack of flash cards and occasionally I'd grab a...
2012-10-25
812 reads
PASS DBA Virtual Chapter Deck and Demo's Live
Hello Dear Reader, I wanted to say a quick Thank You to the PASS DBA Virtual Chapter for having me...
2012-10-25
538 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers