Log File Space Issue Monitoring Using SQL Server DMV
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,794 reads
Making Phone Calls from Azure Event Hub Messages
Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build out...
2017-05-30
16 reads
Making Phone Calls from Azure Event Hub Messages
[read this post on Mr. Fox SQL blog]
Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing...
2017-05-30
1,270 reads
Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)
Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
One of the most important and recurring...
2017-05-30
921 reads
Setting up Cross Database Queries in Azure SQL Database
A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL...
2017-05-30
521 reads
Setting up Cross Database Queries in Azure SQL Database
A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL...
2017-06-12 (first published: 2017-05-30)
3,639 reads
Power BI Custom Visuals Class (Module 53 – Play Axis)
In this module you will learn how to use the Play Axis Power BI Custom Visual. The Play Axis visual...
2017-06-13 (first published: 2017-05-30)
1,672 reads
How To Roll-Back Data in a Temporal Table
Watch this week's video on YouTube
So you've started using temporal tables because they make your point-in-time analysis queries super easy.
Your manager is happy because you're getting historical data to...
2017-05-30
39 reads
SQL Server on Linux Series: Operating System Differences
SQL Server administration, once installed and running, doesn’t vary too much based on your operating system, but the differences in...
2017-05-30
1,032 reads
Ola Hallengren: Output File
I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to...
2017-05-30
366 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers