Predictions for the Future
Steve Jones looks forward with a few predictions for how the world might change for SQL Server professionals.
The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
Decouple the Tools
The decoupling of some tools from SQL Server seems to be working. Perhaps Microsoft should decouple them all.
Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
Quality-Driven Software Development
While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle.
Scripting Environments in SSIS
Demo and script on how to script out SSIS Environments and their associated variables
SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python
Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.
Elevation of Privileges
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers