Some SQL Server Security Housekeeping
Managing SQL Server security changes in mass is something which screams automate it. Let’s look a at few examples using...
2011-11-14
1,660 reads
Blog Posts
SQL Inspire NYC – 2011
The lineup for SQLInspire
I spoke at the SQL Inspire event this last weekend and it was a greart experience. This...
2011-11-14
1,494 reads
SQL Server – Error Msg 102, Level 15, State 1, Line x when using sys.dm_db_index_physical_stats
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,853 reads
SQL Server 2012 licensing
Microsoft has recently released the licensing overview for SQL Server 2012. A few things has changes from SQL Server 2008,...
2011-11-14
950 reads
SQLInspire - Follow-up & Post Event Notes....
This blog entry is a short post-event follow-up for all our followers and attendees at the event! I will have...
2011-11-14
1,013 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a...
2011-11-14
539 reads
SQLInspire NYC 2011
I sit here in a hotel room as I reminisce on this past weekend. This last weekend began with a red-eye trip from Salt Lake to New York. The...
2011-11-14
3 reads
The Industry Problem according to @Way0utWest
Steve Jones (blog/@way0utwest) from SQLServerCentral posted his daily editorial today titled "The Industry Problem" in which he describes an article he...
2011-11-14
1,020 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far...
2011-11-14
1,033 reads
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far as to enter my script into a TSQL Challenge....
2011-11-14
6 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
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...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
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