SQL Server Management Studio Tips
A complete guide to the hidden gems of SQL Server Management Studio (SSMS), covering shortcuts, tips and tricks, useful scripts, and more.
2019-09-18 (first published: 2017-08-14)
16,768 reads
Articles
SQL Server Security: Fixed Database Roles
Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.
2019-09-18 (first published: 2003-12-12)
64,286 reads
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
37,133 reads
Backup Techniques Available Exclusively When Using Azure VMs
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
2019-09-18
Partitioning Data in SQL Server without using Partitioned Tables
In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
2019-09-17
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
2019-09-17
Managing SQL Server containers using Docker SDK for Python - Part 2
There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.
2019-09-16 (first published: 2019-09-10)
1,881 reads
Working with React Components
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application
2019-09-16
Monitoring TempDB Contention using Extended Events and SQL Monitor
Sometimes, a database will slow down exponentially when it is working hard, with many concurrent users. Well, to be more accurate, all the databases on the instance will slow down.
2019-09-13
Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans
In his latest blog posts Brent shares his favourite research papers, explaining why he found them interesting and why you might too. STarting off with the Microsoft Research paper Plan Stitch: Harnessing the Best of Many Plans by Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, and Vivek Narasayya (2018)
2019-09-13
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