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.
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.
The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
Backup Techniques Available Exclusively When Using Azure VMs
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
What You Should Know About Coding
Today Steve thinks about the skills and approach we ought to be taught before we start building software as a career.
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.
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.
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.
The Crazy Times of Year
Do you have busy times of the year that recur regularly? In some positions I've held, we had certain events or processes that always caused additional stress and headaches for employees. As a bartender, certain holidays (New Years, Halloween) were extra crazy. In one company, every quarter was an adventure involving a late, or a […]
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
Blogs
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,...
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...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
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