Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1
Pliant Technology, New Kid On The Block
If you have been reading my storage series, and in particular my section on...
2011-05-23
3,200 reads
Blog Posts
Show correct totals when using SSAS role security
When using role security in SSAS, one point of confusion is when a person sees the grand total for a...
2011-05-23
863 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,387 reads
SQL University Troubleshooting Week Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
697 reads
SQL University Troubleshooting Week: Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
870 reads
SQL Joins and Subqueries
A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...
2011-05-22
1,105 reads
Find your Enabled SQL Server Network Protocols Using PowerShell
Another quick check I like to do when in 'discovery mode' on a client system is to see what network...
2011-05-21
2,071 reads
Forum Fun: Running Calculation SQL
A discussion about a forum post for handling a running subtraction in a SQL query.
For my first forum fun post,...
2011-05-21
672 reads
SQL Rally 2011 Recap
As I write this, I’m somewhere in the air over Florida, headed back home to Dallas from participating in the...
2011-05-21
1,112 reads
Busy is as Busy Does
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
555 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