Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server
The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database...
2012-08-10
1,041 reads
The Smiling DBA
SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...
2012-07-28
963 reads
PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my...
2012-07-22
819 reads
SQL Saturday #150 and TechDay Baton Rouge–BI 1 track
The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks...
2012-07-19
885 reads
PASS BI/DW presents Dimensional Modeling 101–by me…
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach...
2012-07-16
856 reads
I’m Speaking: PASS Summit 2012 and more…
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...
2012-07-12
726 reads
Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,972 reads
Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...
2012-07-08
1,466 reads
MAXDOP and Cost Threshold for Parallelism – an example for a parallel query
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,394 reads
PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
690 reads
Blogs
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:...
Advice I Like: Take Two Trips
By Steve Jones
If you have any doubt about being able to carry a load in one...
Forums
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers