Writing your 2024 PASS Data Community Summit Submission
It is time again for the PASS Data Community Summit Call For Speakers. Some of you are very ready. You have a presentation idea that has percolated since at least last October. You have asked friends and coworkers if it is a good idea. You may have pre …
[Video] Office Hours From the Future
To answer today’s questions from https://pollgab.com/room/brento, I strapped on my Apple Vision Pro and recorded my persona as if we were on a FaceTime or Zoom call together. It’s delightfully creepy, as if I’m AI Brent from the Futur …
Serverless Authentication methods in web apps.
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems. Instead of relying on a dedicated server, authentication tasks are outsourced to cloud-bas …
Read This Before Your Users Install SSMS 20
SQL Server Management Studio 20 Preview 1 is out, and the new connection dialog has a big change: When you click Connect, you’re likely going to get an error: The fastest fix is to click the Encryption dropdown, and change it to Optional: And the …
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities
The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first on SQLServerCentral.
The Value of Conference Speaking
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, so join Jason in throwing your hat into the ring for this year’s Summit coming up in Seattle November 4-8! My Power BI Speaking Tour: This is the Way Over …
Evolving Role of Data Professionals in Artificial Intelligence Era
This image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative AI tools like Gemini, ChatGPT and their underlying large language models (LLMs) have reached unprecedented levels of sophistication. From m …
Building MongoDB Aggregations
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. In the previous article in this series, I discussed how to use a find statement to retrieve data from a MongoDB collection. Howev …
Updated First Responder Kit and Consultant Toolkit for February 2024
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test scripts, and David Wiseman and Sean Killeen implemented basic automated testing for the First Responder Kit. Wanna watch me …
Friendly Deletes in SQL Server
One of the first things you learn when working with SQL Server, and other transactional based SQL systems, is that set based operations perform best. If you are querying data, a cursor pulling individual rows doesn’t perform as well as a single q …
Live webinar: How to excel at managing multiple database platforms
The use of multiple database platforms is on the rise, however, managing them can be challenging, with issues such as data integration, monitoring and a requirement for greater skill diversity. So how can you thrive in this environment? Join industry e …
A Few Best Practices for Strong SQL Server Security
Databases serve as the critical infrastructure for numerous applications. They safeguard essential data that fuels both business operations and strategic decision-making. Given the significance of this role, safeguarding your database is a top priority …
Query Exercise: Finding Sister Locations to Help Each Other
For this week’s query exercise, let’s start with a brief query to get a quick preview of what we’re dealing with:SELECT TOP 100 Location, COUNT(*) AS Population, AVG(Reputation) AS AvgReputation FROM dbo.Users GROUP BY Location ORDER …
Find and Replace Text in Strings in T-SQL
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extrac …
Find Recent Superstars: Answers & Discussion
Your query exercise for this week was to write a query to find users created in the last 90 days, with a reputation higher than 50 points, from highest reputation to lowest. Because everyone’s Stack Overflow database might be slightly different, …