Metadata Functions (OBJECT_NAME for example)
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
852 reads
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
759 reads
SQL Server – How to Enable a Disabled SQL Server Login
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
987 reads
Dynamic calculations of running totals
Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...
2013-06-24
1,316 reads
Natural Born Killers (The series) – Day 5 Key Lookups
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-24
722 reads
ASP.Net MVC Debugging "Internal Server Error 500"
I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...
2013-06-22
555 reads
Moving a database from on-premise to the cloud – Step by Step Walkthrough
Cloud is the future and moving there is now as easy as few mouse clicks.
Today we will see how an...
2013-06-21
1,454 reads
Reblog: June 14 to June 20
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-21
852 reads
Key Change
I love music. In fact, I like to think that I’m a student of music – although anyone who has heard...
2013-06-21
1,015 reads
Managed Service Accounts - The Saviour for the Domain-based SQL Server Service Account?
For those Database Administrators seeking to lock-down security related to a Service Account(s), there is an option starting with Windows...
2013-06-21
2,252 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers