SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
699 reads
10 signs you're not talking to a developer
Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same...
2013-09-16
849 reads
SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time
Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...
2013-09-16
503 reads
Order of a Result Set in SQL
I have seen people build procedures that rely on a result set being returned in a certain order. This is...
2013-09-14
768 reads
Windows Azure Service Dashboard – Checkout the health of Azure Services
Windows Azure Service Dashboard is an excellent way to know the health/availability of your Windows Azure Services.
You might always want...
2013-09-13
1,329 reads
Reblog: September 6 to September 12
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-13
885 reads
Join The SQL Crazy Train
One of the best lines I heard in the past few weeks was “That train has sailed.” Combine that with a crazy schedule and we now have a SQL...
2013-09-13
8 reads
Join The SQL Crazy Train
One of the best lines I heard in the past few weeks was “That train has sailed.” Combine that with...
2013-09-13
899 reads
Are Foreign Keys Better Than Indexes?
When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...
2013-09-13
947 reads
Q&A From “5 Ways to Improve Performance through Indexing”
A few weeks back spoke at a Pragmatic WorksTraining on the T’s on indexing that was titled 5 Ways to Improve Performance through...
2013-09-13
684 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers