SQL Server

How to Generate Fake Test Data for SQL Server

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

How to use a SQL random data generator to fill SQL Server tables with realistic test data, to shift left database unit testing, integration testing and performance testing so that it is performed during the early stages of database development.

2021-05-03

SQL Server Memory Usage Query

• by Additional Articles

• MSSQLTips.com

• Monitoring
• SQL Monitoring
• sql server monitoring

• Article

Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.

2021-05-03

Building a SQL Server data dictionary

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.

2021-04-29

Five Facts about the SQL Server Resource Database

• by Additional Articles

• MSSQLTips.com

• system database
• System databases

• Article

In this article we cover interesting facts about the hidden resource database in SQL Server and how this is used by SQL Server.

2021-04-28

Learn basics of Data Wrangling in SQL Server to handle Invalid Values

• by Additional Articles

• MSSQLTips.com

• data cleansing

• Article

In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.

2021-04-23

SQL Server Security – Fixed server and database roles

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.

2021-04-22

Tell us about how you monitor your databases

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• 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

• cross platform
• Data Platform

• 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

• C#
• Export
• export data
• import

• Article

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

2021-04-13