Last restart of SQL Server
Occasionally I need to see what the date of last restart of SQL Server. The old method isto check the...
2010-12-17
1,079 reads
Blog Posts
SAC in SQL 2008 (R2)
SAC (Surface Are Configuration) was the great possibility to configure the SQL Server 2005, so there were some options to...
2010-12-17
1,484 reads
Social Leadership And The SQL Community
2010 is rapidly coming to a close and in retrospect this has been a fantastic year of growth for the...
2010-12-17
1,185 reads
The Bar Where Everyone Queries Your Name?
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
582 reads
T-SQL Tuesday #13 Roundup
After my call for “What the Business Says Is Not What the Business Wants”, there were quite a few people...
2010-12-17
1,318 reads
Unusual BBQ
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
594 reads
1.5 Years in, U.K. Information Commissioner Christopher Graham, Delivers on the Data Protection Act
A year after the Telegraph reported that Information Commissioner Graham would pledge a fierce approach to the stonewalling approach of...
2010-12-16
1,477 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today...
2010-12-16
836 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change the format of its data feed. Evidently, today is not every day. It would be one thing...
2010-12-16
13 reads
Behold, SSIS Advanced Editor for Data Source Components
It's not everyday that one of your information vendors decides to change
the format of its data feed. Evidently, today is not every day. It would
be one thing...
2010-12-16
15 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