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,947 reads
Blog Posts
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
14 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
291 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,603 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
261 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
7 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
4 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
7 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
194 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,258 reads
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers