2014-09-26
4 reads
Blog Posts
2014-09-26
2 reads
2014-09-26
9 reads
Re-Indexing – The quest of ultimate automation
In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a...
2014-09-26
624 reads
Wait Statistics #4 LCK_M_xx
In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...
2014-09-26
1,272 reads
Why I’m Only Casting One Vote This Year in the PASS Election
First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are...
2014-09-26 (first published: 2014-09-23)
6,525 reads
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,106 reads
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,581 reads
Four Big Things PASS Could Do Next Year
Here’s my wish list:
Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring...
2014-09-25
735 reads
Installing SQL Server 2014 Language Reference Help from disk
Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.
For some reason that I...
2014-09-25
954 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