T-SQL Tuesday 107 – Viral Demo
For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...
2018-10-19 (first published: 2018-10-09)
1,874 reads
Blog Posts
Contextual View Part II or how to hide sensitive data
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
542 reads
Creating Wait stats widget on Azure Data Studio for macOS
A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...
2018-10-18 (first published: 2018-10-09)
2,566 reads
Step-by-Step: How to Trigger an Email Alert from Windows Performance Monitor
Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...
2018-10-18
1,631 reads
The Project Graveyard
This post is a response to this month’s T-SQL Tuesday #107 prompt by Jeff Mlakar. T-SQL Tuesday is a way...
2018-10-18 (first published: 2018-10-09)
2,726 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
296 reads
Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,060 reads
How to Start Speaking
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
340 reads
Pagination pattern or how to fetch a large dataset for a web report.
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
419 reads
SQL Server Data Collection and Management Data Warehouse
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,474 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers