Additional Articles

Introduction to Azure Cosmos DB Security

by Additional Articles

SQLServerCentral

Security

When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies. In addition, when dealing with data services, it is also necessary to distinguish between the data plane, facilitating access to the underlying content and the management plane, which allows for delegation of administrative tasks. In this article, Marcin Policht explores how these concepts apply to the Azure Cosmos DB offering.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2018-06-05

2,582 reads

Importing JSON Collections into SQL Server

by Additional Articles

SimpleTalk

JSON

Microsoft introduced native support for JSON in SQL Server in version 2016. In this article, Phil Factor shows how to import JSON documents into to SQL Server database tables, even if there is a bit of complexity in the original data.

2018-06-04

3,180 reads

Quick Tips For Debugging Large Stored Procedures

by Additional Articles

Brent Ozar Blog

T-SQL

SSMS is a good management tool, but it’s not a good development tool. When you’re writing some simple queries, it’s fine. When you’re writing code with lots of branching, dynamic SQL, temp tables, error handling, and so on… Not so much. Here are some tips Erik darling has put together after a couple years of wrangling the Blitz scripts in the First Responder Kit.

2018-06-01

4,954 reads

Automating a SQL Server Database Refresh

by Additional Articles

MSSQLTips.com

refresh

In this tip we cover the basics of what needs to be done to setup a process to automate refreshing a dev or test environment with a recent database backup.

2018-05-31

4,463 reads

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

by Additional Articles

SimpleTalk

PowerShell

Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.

2018-05-30

4,458 reads

Tables Without Clustered Indexes

by Additional Articles

SQLServerCentral

clustered index

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2018-05-29

4,777 reads

Create Azure VMs with PowerShell Part 2

by Additional Articles

SimpleTalk

PowerShell

In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.

2018-05-28

3,337 reads

Where Clustered Index Keys Dare

by Additional Articles

Brent Ozar Blog

clustered index

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes.
But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.

2018-05-25

3,638 reads

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

by Additional Articles

MSSQLTips.com

Database Mail

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.

2018-05-24

3,084 reads

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

by Additional Articles

SimpleTalk

SQL Server

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.

2018-05-23

3,068 reads

All authors

Additional Articles

Introduction to Azure Cosmos DB Security

Importing JSON Collections into SQL Server

Quick Tips For Debugging Large Stored Procedures

Automating a SQL Server Database Refresh

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

Tables Without Clustered Indexes

Create Azure VMs with PowerShell Part 2

Where Clustered Index Keys Dare

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

Blogs

Microsoft Tools for Making Data AI-Ready

Local Models Using GPUs with Ollama

Don’t Fear the Technology

Forums

Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure

Reserved Words I

Get Along

Question of the Day

Reserved Words I