Reblog: May 30 to June 5
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-06-06
768 reads
Blog Posts
Speaker of the Month, June 2014
It’s not like I can’t find plenty of great presentations here in the US, but, while I was over in...
2014-06-06
751 reads
Using a Hyper-V VHD in an Azure VM
I’m in the process of moving some my lab environments that I use for teaching SQL Server classes to Azure....
2014-06-06
1,288 reads
Attaching All Databases with PowerShell–Refactoring out Write-Host
Someone posted a note to me on Twitter that noted that Write-Host is not recommended for your scripts. I checked...
2014-06-05
1,042 reads
Natively Compiled Procedures and Execution Plans
The combination of in-memory tables and natively compiled procedures in SQL Server 2014 makes for some seriously screaming fast performance....
2014-06-05
1,361 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,620 reads
15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,050 reads
A Sherlockian Question Of the Day & Why I’m Writing Questions
If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started,...
2014-06-04
331 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-06-04 (first published: 2014-05-28)
1,997 reads
Miscellaneous Notes on the PASS NomCom and General Election
Interesting day yesterday. A spirited discussion on Twitter, a challenging post from candidate Mark Broadbent, and a couple good threads...
2014-06-04
646 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers