There are seven common antipatterns in T-SQL coding that make code perform badly, and three good habits which will generally ensure that your code runs fast. If you learn nothing else from this list of great advice from Grant, just keep in mind that you should 'write for the optimizer'.
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
There are often Shadow IT groups in many companies. Steve Jones talks about the potential problems of these groups, and how he has dealt with them in the past.
Can I export images from SQL Server to a file in Windows? What SQL Server options are available to do so? Check out this tip to learn more.
A free day of training in Columbus, GA. Come meet the local SQL professionals and spend a day talking SQL Server.
This week Steve Jones looks at some of the jobs being outsourced and how that might affect data professionals.
Intuit manages ten million lines of code in a single codebase and does a great job of it. Read a little about what they do.
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.
This Friday Steve Jones wants to know how you spend your time. Do you get to do a lot of new development or do you end up fixing, tuning, and improving old code. Let us know.
This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
I am not sure which is the best way to proceed. I have parent...
Comments posted to this topic are about the item Hyperscale Replicas III
Comments posted to this topic are about the item Development Is Fun
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers