Spread the Word about Basic Security
This week we have a few back to the basics security comments from Steve.
Displaying the Object Explorer Details Pane in SQL Server Management Studio
You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...
SQL Clone on your Laptop
Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.
Killing FTS
Steve wonders today if the Full-Text Search system in SQL Server is due for a replacement, perhaps with other technologies.
Database provisioning and containers – can you help?
If you work with SQL Server, Redgate would love to talk to you about how you’re using (or thinking of using) containers, how you see databases fitting into your workflows involving them, and any challenges you’ve hit so far.
Free Webinar: The State of SQL Server Monitoring 2019
With a line up like this, it's a webinar not to be missed! Join Grant Fritchey, Chris Yates, Annette Allen, and Tony Maddonna on Tuesday June 25th as they discuss the key findings of Redgate’s 2019 State of SQL Server Monitoring survey.
The BI Journey: The Journey Begins
Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
Group Managed Service Accounts (gMSAs) in SQL2016
Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON
Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers