Using Registered Servers in SSMS
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection di …
Getting Started with Azure CLI to Manage Azure Resources
The post Getting Started with Azure CLI to Manage Azure Resources appeared first on SQLServerCentral.
PASS Summit Futures Scholarship
The post PASS Summit Futures Scholarship appeared first on SQLServerCentral.
Free Online SQL Server Internals Conference Next Week
The EightKB conference is a free event that focuses on SQL Server internals. You can get the session details and register for the August 8th event at eightkb.online. The session lineup is below, each link being a calendar invite just so you can block o …
5 Ways to Spend Your 2024 Learning and Development Budget in the US
Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This is something I encourage you to negotiate when you are considering a job or at your annual review. We all need to learn and a b …
Fall is around the corner, and hence the PASS Data Community Summit, too
Welcome to the dog days of summer in the Northern Hemisphere. It is hot, so if you are like me you, are preparing for the Fall, with cooler weather and the start of the holiday season. While the Great Pumpkin may leave you sitting in a pumpkin patch al …
Getting Started With Azure Cosmos DB for PostgreSQL
Article Overview In this article we will learn about Azure Cosmos DB PostgreSQL, which is the latest addition to the already existing family of various database API’s supported by Azure Cosmos DB. Azure Cosmos DB for PostgreSQL capability enables to bu …
How to Stream Data from Azure Event Hubs into a Fabric Eventhouse
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This shows the commitment of Microsoft to make Fabric your one-stop shop for all things data analytics, both stream …
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include 65,437 responses from developers around the world. The results are biased towards the kinds of developers who use Stack Ov …
Migrate a SQL Server Database to a PostgreSQL Database
The post Migrate a SQL Server Database to a PostgreSQL Database appeared first on SQLServerCentral.
[Video] Office Hours in a Mexican Hot Tub
While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. https://www.youtube.com/watch?v=OaHImrIMM6Y Here’s what we covered: 00:00 Start 01:00 OpportunityKnocking: What are your thoughts on when to …
Auditing SQL Server – Part 3 – SQL Server Configuration Audit This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware configuratio …
Query Exercise Answer: Fixing a Slow Computed Column
In last week’s Query Exercise, we added a user-defined function to the Users table to check whether their WebsiteUrl was valid or not. I noted that even with an index on Reputation, SQL Server 2022 simply ignored the index, did a table scan, and …
Announcing New Membership Tiers: Free & Mentoring
I give away a lot of stuff in various places on the internet: videos, scripts, the new free tier of SQL ConstantCare®, and I’ve got more tricks coming soon. But until now, it’s been kind of a hassle because they’ve been scattered all …
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about how non-clustered indexes are expensive to store and maintain, that they can occupy valuable space in memory, and that they can nega …