Deferred-drop tipping point
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,770 reads
Blog Posts
Building The SQLSaturday Orlando Marketing Plan-Part 15
After doing some local exploring of the idea of delivering certificates of completion I don’t think it’s enough of a...
2014-05-30
1,251 reads
Configuring SQL Server Database Mail Feature
You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also...
2014-05-30
1,488 reads
Database capacity planning and management
As part of the planning and research before implementing new SQL Server, you must determine the amount of space needed...
2014-05-30
4,909 reads
Do you apply SQL Server Cumulative Updates?
I think Steve Jones makes a great point here with respect to cumulative updates:
“This is one reason I’ve been hesitant...
2014-05-30 (first published: 2014-05-28)
6,883 reads
Friday Followup For May 30, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-05-30
1,002 reads
Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure
An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package...
2014-05-30
1,300 reads
MDX #41–Remove employees with less than $100,000 sales
Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...
2014-05-30
1,487 reads
Quick Tips–SQL Prompt Qualifying Columns
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-05-30 (first published: 2014-05-28)
1,738 reads
SQL #54–Casting numbers with white spaces as Integer will fail
Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...
2014-05-30
1,541 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
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers