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
755 reads
Blog Posts
Don’t Use MD5
“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably...
2013-06-24
931 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,305 reads
I Don’t Care
It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...
2013-06-24
739 reads
Last Weeks Top “Reading” Links #38
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-24
1,122 reads
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
846 reads
My upcoming SQL Server Trainings
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...
2013-06-24
1,282 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
721 reads
Recently Recompiled Resource Hogs
It’s not too uncommon for a query to get a new execution plan that performs a lot worse than it...
2013-06-24 (first published: 2013-06-19)
1,807 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
982 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers