Webcast: Data Modeling Scenarios and Best Practices
On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for...
2018-12-28
1,320 reads
Blog Posts
Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell
I was asked by the reader on how to get all the port information of SQL Servers instances. As you...
2018-12-27
530 reads
Basic Sequences–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-27 (first published: 2018-12-05)
2,498 reads
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
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,976 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,656 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
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
262 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
16 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers