Early Adopters
Today we have a guest editorial from Andy Warren that looks at those that run software early in its lifecycle.
Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts
There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results.
Shrinking the Budget
Most DBAs don't get involved with budgets at work, but we are affected by them. Steve notes you might want to understand how budgets work.
Installing SQL Server 2016
Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.
Webinar: Unit Testing in SQL Server with tSQLt
Join tSQLt developer, Sebastian Meine, and Steve Jones as they answer your questions and show you how to unit test T-SQL code.
Relational By Default
Should we consider the relational model the default and only after having a good reason look at a NoSQL platform? Steve Jones has a few comments.
SQL Prompt Tips #6 - Insert Semicolons
A quick SQL Prompt tip to automatically add semicolons to your code.
Is SQL Server killing your application’s performance?
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server.
Private Data
The laws and morals regarding privacy aren't well defined, but Microsoft is making a stand.
Database Lifecycle Management Webinar
Join Steve Jones for a Database Lifecycle Management webinar on Nov 17 at 11am EDT. Watch to see how smooth a database development pipeline can be.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
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,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers