Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
690 reads
Blog Posts
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,001 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
710 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
547 reads
First Birthday to My Blog
Today is the First year anniversary of my blog. After thinking a lot and going through many un-imaginable resource available over...
2014-04-10
310 reads
Heartbleed bug: immediate security threat for both IT, and consumer sites and services
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
694 reads
I’m a Traveling Man
We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...
2014-04-10
790 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
799 reads
Smart Moves with SQL Server VMs – Data Movement
Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...
2014-04-10
960 reads
Webcast Follow-Up: Introduction to Columnstore Indexes
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-04-10
836 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