Clone a SQL Server login and password to a new server
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
2017-03-03
4,570 reads
Articles
Configure SSRS with an SSL Certificate
A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.
2017-03-02
146,729 reads
How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
2017-03-02
3,772 reads
DevOps and “Shift Left” for Databases
The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least...
2017-03-01
5,552 reads
2017-02-28
11,477 reads
One way to get an index seek for a leading %wildcard
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
2017-02-28
5,792 reads
Performance Dashboard Error: Could not find stored procedure
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
2017-02-27
2,006 reads
Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data
SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.
2017-02-27
5,321 reads
The Last Week for SQL Bits 2017 Discounts
This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.
2017-02-27
3,107 reads
Enumerate Windows Group Members
Here a quick script showing how to get all the Active Directory users in a AD group.
2017-02-24 (first published: 2016-03-17)
8,878 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers