How to: File Target use in Extended Events
Using a file target is not difficult from a creation point of view (event session creation). But, some basics are critical or you could end up with fewer follicles.
Related...
2018-12-27
16 reads
Blog Posts
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of...
2018-12-27
2,999 reads
My SQL Server Travels in 2018
It’s the end of the year, and I’m looking back at the events and travels I’ve had this year. I...
2018-12-27
293 reads
Seeing WriteLog wait type on your SQL Server?
One of the more common wait types for SQL Server is called WriteLog. In its most basic form it is...
2018-12-27 (first published: 2018-12-18)
3,678 reads
SQL server change single user mode or backup or recovery model of all database sql script
AdvertisementsFollowing is the DBA script which generally used for most cases the action needed for all the databases like migration,...
2018-12-27
266 reads
SQL server change single user mode or backup or recovery model of all database sql script
Following is the DBA script which generally used...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2018-12-27
9 reads
Watch: The Best of 2018 and Predictions for 2019 (video)
I recently got together with fellow Microsoft Data Platform MVPs Steve Jones, Kathi Kellenberger and Grant Fritchey to discuss the highlights of innovations we’ve seen in 2018 and predictions...
2018-12-27
20 reads
Adding Microsoft MVP Contributions with PowerShell – Lessons Learned using the MVP API
One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem,...
2018-12-26
14 reads
Giving thanks in 2018
It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is...
2018-12-26
196 reads
Managing Logins and Users Across An Availability Group
What’s the deal with logins and availability groups?
I’m sure that we all, when creating a login that accesses a database...
2018-12-26 (first published: 2018-12-05)
2,280 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