SQL Server

Article

The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

2021-04-19

SQL Window Functions in SQL Server, Oracle and PostgreSQL

by Additional Articles

MSSQLTips.com

Article

In this article we look at using Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities of the syntax.

2021-04-19

What to monitor for SQL Server security

by Additional Articles

SimpleTalk

SQL Server security

Article

Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.

2021-04-16

Export SQL Server Data to Excel and Add New Columns with C#

by Additional Articles

MSSQLTips.com

Article

Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.

2021-04-13

Five facts about the SQL Server Model Database

by Additional Articles

MSSQLTips.com

Article

In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.

2021-04-08

Discuss

Where I See Databases Going in the Next 10 Years

by Additional Articles

Brent Ozar 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

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

Article

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

2021-03-22

SQL Server

Tell us about how you monitor your databases

SQL Window Functions in SQL Server, Oracle and PostgreSQL

What to monitor for SQL Server security

Export SQL Server Data to Excel and Add New Columns with C#

Five facts about the SQL Server Model Database

Where I See Databases Going in the Next 10 Years

Combine Multiple SQL Server Query Results with Registered Servers

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

Scripts to Automate Creating and Loading a SQL Server Table

Five facts about the SQL Server Tempdb Database

Blogs

The #MS_DatabaseConnector## Role: #SQLNewBlogger

Asking for Help Isn’t a Weakness

The Proof of the Backup Is in the Pudding

Forums

Pay for Performance

Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444

Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444

Question of the Day

The ##MS_DatabaseConnector## User