Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
Help us define the State of Database Monitoring in 2020
The State of SQL Server Monitoring was launched in 2018. This year we are interested in gathering insight across database platforms, not just SQL Server. Have your say and take the survey to be first to receive the report and enter your chance to win a $500 Amazon voucher.
Take the survey.
The First Time I Had to Restore a Database
Do you remember the very first time you had to do a database restore to fix something you messed up?
Implementing Reporting Application Enhancements with No Downtime
The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
Who is the best person for the job?
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
SQL Server Disaster Recovery Options
This presentation is to get you thinking about the disaster recovery options for SQL Server, things like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise.
More Time to Certify
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
Stairway to U-SQL Level 16: The Azure Data Lake Catalog
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Stairway to U-SQL Level 16: The Azure Data Lake Catalog
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Working with SQL Cursors
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them
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...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
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