Outlier Detection with SQL Server, part 3.2: GESD
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...
2014-12-22 (first published: 2014-12-17)
6,618 reads
Blog Posts
ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,856 reads
Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of...
2014-12-22
8 reads
Use of RPC in Cluster
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is...
2014-12-22
1,506 reads
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
648 reads
Change Tracking–an easy way to track your changes TIP#78
I am pretty much sure by the title of this post you had idea of the post content. Although I...
2014-12-21
706 reads
Easy way to reseed identity column ? TIP #77
Sometimes, we may require to reseed identity column of a table due to various reason.
For example we have deleted a...
2014-12-20
529 reads
New Power BI stand-alone Designer, Dashboards, APIs & iOS App
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why...
2014-12-20
692 reads
Friday Followup For December 19, 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-12-19
439 reads
Getting Started with the Power BI Dashboards Public Preview
If you’re currently an Office 365 customer that is using Power BI sites then you probably found an early Christmas...
2014-12-19
1,252 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
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
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?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers