2015-03-27
925 reads
Blog Posts
Measuring My Career
I’m going to do a shorter editorial on this, but really I think this deserves more treatment here.
I saw Brent...
2015-03-27 (first published: 2015-03-19)
7,145 reads
The April Blogger Challenge
I’d encourage you to take Ed Leighton-Dick’s challenge to blog in April. Read his post, start writing, and put your...
2015-03-27
605 reads
Women in Technology
Warning: rant forthcoming.
I don’t get the women in technology problem. Oh, I understand and see the problem. I also understand...
2015-03-27 (first published: 2015-03-18)
6,922 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL...
2015-03-26 (first published: 2015-03-19)
15,683 reads
Database Restores – Zeroing Out Log Files
I recently came across a question on the #sqlhelp Twitter feed that I thought was interesting. The question pertains to...
2015-03-26
470 reads
How to resequence column based on numeric prefix using TSQL
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...
2015-03-26 (first published: 2015-03-19)
6,316 reads
Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
658 reads
Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
275 reads
Clean out all bad characters from a string.
I have a customer who is having a problem with a load. He is getting a fair number of bad...
2015-03-25
1,107 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers