SQL Server

Where I See Databases Going in the Next 10 Years

• by Additional Articles

• Brent Ozar Unlimited Blog

• SQL Server

• Article

This month, to mark the 20th anniversary of BrentOzar.com, Brent steps back and looks at the big picture.

2021-04-06

Combine Multiple SQL Server Query Results with Registered Servers

• by Additional Articles

• MSSQLTips.com

• Central Management Server (CMS)
• Central management servers

• Article

Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.

2021-03-29

Checking for Missing Module References in a SQL Server Database Using Flyway

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.

2021-03-25

Scripts to Automate Creating and Loading a SQL Server Table

• by Additional Articles

• MSSQLTips.com

• T-SQL

• Article

Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.

2021-03-24

Five facts about the SQL Server Tempdb Database

• by Additional Articles

• MSSQLTips.com

• SQL System Database
• system database
• System databases

• Article

In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.

2021-03-22

Encrypt and Decrypt Passwords in SQL Server with PowerShell

• by Additional Articles

• MSSQLTips.com

• PowerShell
• Security

• Article

In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.

2021-03-17

Delete SQL Statement in SQL Server, Oracle and PostgreSQL

• by Additional Articles

• MSSQLTips.com

• Data Platform
• multi-platform

• Article

Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.

2021-03-16

Reusing Query Results in SSMS

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.

2021-03-16

SQL Server authentication methods, logins, and database users

• by Additional Articles

• SimpleTalk

• Learn SQL

• Article

Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.

2021-03-15

T-SQL Tips and Tricks

• by Additional Articles

• MSSQLTips.com

• T-SQL

• Article

In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server

2021-03-10