Product Platform Teams
Today Steve notes that DevOps isn't going to eliminate Ops, even if developers support their own applications.
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
Deploying Data and Schema Together with SQL Compare or SQL Change Automation
You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.
SSRS is Still Around
The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news about the general availability of SQL Server 2019, I had not heard any recent news about SSRS, so I could only say that I didn’t know.
Data for Defense
The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.
Increase Query Speed with Covering Indexes
Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.
Implementing SQL Server Integration Services with Azure Data Factory
Read on to step through the process of implementing Azure Data Factories.
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers