Strengths Finder 2.0
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development....
2011-07-27
891 reads
The Scary DBA
PASS SQL Rally 2011 Evaluations
In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals...
2011-07-05
925 reads
Presentations in Action
The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation...
2011-06-27
632 reads
Make the Optimizer Work Harder
One of my favorite indicators for whether or not you have a good execution plan is when you see the...
2011-06-20
2,780 reads
Rebind and Rewind in Execution Plans
Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query,...
2011-06-15
4,853 reads
Time for a Little PD
No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I...
2011-06-13
731 reads
SQL Cruise Alaska 2011
Yes, I went on the SQL Cruise to Alaska. Yes, it was as grand as you’ve heard. Yes, I’m going...
2011-06-08
529 reads
Optimizer Timeouts with XQuery
I was looking at performance of a database and I noticed a few of the plans were very large and...
2011-05-30
2,108 reads
Oh ****!
Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...
2011-05-25
908 reads
SQL Azure Query Tuning
SQL Azure is still SQL Server at the end of the day. This means it is entirely possible to write...
2011-05-23
1,379 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Simple Junction table design question
I have a disagreement with the programming team on an app that I designed....
Sql query to check the status change for an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers