Outlier Detection with SQL Server, part 2.1: Z-Scores
By Steve Bolton
…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex...
2014-10-28
2,854 reads
Blog Posts
Session: Introduction to Powershell Cmdlets for DBAs
I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged...
2014-10-28
883 reads
SQL Server – Failed to bring availability group ‘[availability group name]’ online
I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON...
2014-10-28
2,005 reads
SQL Server TABLESAMPLE
Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...
2014-10-28 (first published: 2014-10-20)
7,478 reads
A script to list the DTS connection information for every package on the instance.
For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...
2014-10-27
674 reads
Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !
The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the...
2014-10-27
18 reads
Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !
The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-10-27
801 reads
Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
168 reads
EXEC sp_executeSQL
Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure...
2014-10-27
12 reads
Last Weeks Top “Reading” Links #106
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-27
451 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