Stepping Stone Cert
A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM...
2010-03-30
1,534 reads
SQL RNNR
FizzBuzz Revisited
I had bigger plans for this series than what has transpired. I think that is a testament as to how...
2010-03-30
1,939 reads
Certification
There seems to be quite a flurry of talk these days about certification. There is evidence of it in the...
2010-03-26
1,258 reads
Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,774 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
620 reads
Log Growing Pains Article
I Just had an article published at SQLServercentral on troubleshooting the cause of log growths. At the conclusion of that...
2010-03-11
471 reads
IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,350 reads
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral...
2010-03-05
750 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
862 reads
DBA MD
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It...
2010-02-25
598 reads
Blogs
SQL Inventory Dashboards: From Raw Data to Real Insight
Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Forums
Isolation Level in Azure SQL Database
Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...
Question of the Day
CONCAT_WS
What output do the queries produce?
SET CONCAT_NULL_YIELDS_NULL ON; SELECT CONCAT_WS ('-', NULL, NULL); SET CONCAT_NULL_YIELDS_NULL OFF; SELECT CONCAT_WS ('-', NULL, NULL);See possible answers