2018-05-29
9,071 reads
Articles
Tables Without Clustered Indexes
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.
2018-05-29
4,777 reads
Configuring R Services in SQL Server 2016
R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.
2018-05-28 (first published: 2016-01-27)
4,899 reads
Create Azure VMs with PowerShell Part 2
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
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
2018-05-24
4,483 reads
Build and Automate a SQL Server Status Report on Server Restart or Scheduled
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
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
Scheduling a PowerShell Script Using SQL Server Agent
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
2018-05-22
40,813 reads
Why Are You Dropping and Recreating Your Indexes?
Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?
2018-05-22
5,535 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers