Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing and why we need to do it.
My code is...
2015-03-03
15 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
64 reads
Unit Test Sql Server Code
In part 3 of this series of blogs on “getting more agile” I am going to look at unit testing...
2015-03-03
55 reads
How to Fix Latch Problems when Working with Ascending Keys in SQL Server
Traditionally, we want our Clustered Index to have the following attributes:
Narrow: So that our clustered index and the non-clustered indexes that point...
2015-03-03
678 reads
50 Shades of Brown – The Series
That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to...
2015-03-03
660 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
173 reads
Simple-Talk Article
In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated...
2015-03-03
841 reads
SQL Server, Error message 1785, and cascading deletes: How it kills kittens
I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete...
2015-03-03
1,109 reads
Should I check tempdb for corruption?
You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need...
2015-03-02
4,596 reads
SQLSaturday Phoenix Wrap-Up
We had a great day at SQLSaturday Phoenix this weekend! The weather was beautiful (about 60°F warmer than at my home...
2015-03-02
246 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
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers