SQL Server Central
Online/Digital
SQLServerCentral is the #1 education and community site for SQL Server. It has 819,000 members (as of right now), 2.5 million pageviews/month and is growing fast. SQLServerCentral provides a central hub for the SQL Server Community where they can interact with their peers and access the accurate, relevant, and timely technical information that they need to do their jobs. Its focus is on educating SQL Server users by providing a central hub for the SQL Server community. The site is driven by original content developed by our columnists and based on the real world problems they encounter working with SQL Server in their careers. Source
Actions
Media Outlet details
| Scope | Trade/B2B |
|---|---|
| Language | English |
| Country | United Kingdom |
|
Similarweb UVM |
Request pricing |
|
Comscore UVM |
Request pricing |
Recent Articles
Search ArticlesIdentify SQL Servers with inefficient Power Plans
Problem A lot of people are coming to the realization that their CPU performance may be hindered due to a poor default (and recommended) setting in Windows Server: the “Balanced” power plan. As Glenn Berry reports in a recent blog post, with no other changes, simply switching from the balanced power plan to the high-performance power plan can yield an improvement of roughly 20%. If you are currently using the “Power Saver” plan, you can expect an even more dramatic improvement.
A Practical Approach to Automating SQL Server Email Notifications
Email notifications are a common requirement in SQL Server environments. An application may need to notify a customer when an order is created, alert an administrator when inventory falls below a threshold, or send a reminder when a record requires attention. SQL Server Database Mail is one option for implementing these workflows. However, some notification processes involve more than sending a message.
Why Ai Agents need an eval framework
AgentDBA (the database agent I have been building) has more than 1000 automated tests, and until this week none of them measured a single decision the model makes. Every test that runs the agent loop scripts the model’s replies. The … Continue reading ?
How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault
If you’ve ever developed a Gen1 dataflow to connect to an external API (Application Programming Interface), you know the awkward moment when you have to paste an API key into the Power Query script. There it sits, in plain text, inside an artifact (the proper name for something like a semantic model, report or dataflow created in the service), with limited options for secret rotation or .
Tracking Inserted, Updated, and Deleted Rows with SQL Server OUTPUT
Introduction An INSERT, UPDATE, or DELETE statement changes data, but sometimes we also need information about the rows that were affected. For example, an insert may generate identity values, an update may require both the old and new values, and deleted rows may need to be preserved before they are removed. SQL Server provides the OUTPUT clause for these situations.
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
, This week I was at PASS Data Community Summit in Seattle, and I attended a session called “An Inside Look at How Microsoft Builds SQL Features, by Bob Ward, Naveen Prakash, and Travis Wright, all of whom are on the SQL Server team. In this session, Travis mentioned that they reduced the SQL Server container image size by a meaningful amount using AI agents that helped discover unused code in the image, but details on how much and when were lost when the conversation moved on to the next topic.
A New Word: Semaphorism
semaphorism – n. a conversational hint that you have something personal to say on the subject but don’t go any further – an emphatic nod, a half-told anecdote, an enigmantic “I know the feeling” – which you place into conversations like those little flags that warn diggers of something buried unerground: an unexploded bomb, a sacred burial ground, or a high-voltage cable that secretly powers your house.
Implementing System-Versioned Temporal Tables in SQL Server: A Practical Guide
Introduction Questions like “What was this product’s price last month?” or “Who changed this customer’s address, and what was it before?” may come up often in an enterprise application.To address such situations, traditionally, teams handle this with database triggers, audit tables, or custom tracking in the application layer. These approaches can work, but they often add extra maintenance and complexity.
What does my SQL Server data look like over the wire?
Problem How can I see what the outgoing and incoming traffic to my SQL Server instance looks like? Are there any tools that can help with this? Check out this tip to learn more. Solution I have been wondering this same thing. I decided to build a test lab to find out. I will tell you up front that I am not a network engineer, I’m a DBA. So don’t expect to much detail on the network packet stuff. In this tip I will go over what I used for the test, how I set it up, and what I used to test it.
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about something almost every SQL Server DBA uses: SQL Server Management Studio.There were several SSMS announcements during the keynote, but the one that’s probably going to get the most attention is this: GitHub Copilot Agent Mode in SSMS is generally available. Now, before you roll your eyes and say…“Great. Another AI tool that can write a SELECT statement.” This is a little more interesting than that.