Another reason that T-SQL beats the GUI
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
574 reads
SQL Awesomesauce
Things I Favorited on Twitter (a weekly wrapup, of sorts)
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
934 reads
SQL Tribal Knowledge
Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...
2011-11-01
869 reads
Applied SQL: Demonstrate Simple Backup and Restore
Let’s apply a little backup and restore knowledge, eh wot?
I introduce this whole concept in Applied SQL: You Have Homework....
2011-10-26
799 reads
Un-SQL Friday #006: Living in the Intertubez
We’ve had some BIG fun this week, relatively speaking, with #SQLSue and #SQLIdiot and just general #SQLcraziness. We’ve had several...
2011-10-20
598 reads
RSS Tuning Whitepaper notes and clarifications
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
665 reads
Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!
Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...
2011-10-18
679 reads
PASS Summit 2011 Day 3 – Keynote Live Blog with Dr. DeWitt!
Today’s keynote with Dr. DeWitt starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-14
1,681 reads
PASS Summit Day 2 – Women in Technology Live Blog
Jes Borland Hosts the 2011 WIT Luncheon
Click here to watch today’s WIT luncheon live. For information on today’s luncheon and...
2011-10-13
874 reads
PASS Summit 2011 Day 2 – Keynote Live Blog
Today’s keynote with Quentin Clark starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-13
600 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers