Testing PowerShell Modules with Pester
In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.
2018-11-12
2,113 reads
Additional Articles
Unused Indexes - Are they really unused or have they just not been used YET?
Tara explains when index DMVs gets reset by telling a story from her dark past.
2018-11-09
3,197 reads
Azure EA Financial Reporting and Granular Access to Data Through the Enterprise
With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.
2018-11-08
2,241 reads
Simple way to Import XML Data into SQL Server with T-SQL
In this tip we look at a simple way to import a simple XML document into a SQL Server table.
2018-11-07
3,140 reads
How Big is Your Transaction Log?
If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.
2018-11-06
3,724 reads
Azure and Windows PowerShell: Using VM Extensions
In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.
2018-11-05
2,274 reads
5th annual “Seattle Freecon”
On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE.
2018-11-02 (first published: 2018-10-29)
3,203 reads
Index Tuning Week: How Many Indexes Are Too Many?
When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each.
2018-11-02
4,276 reads
HIPAA and Database Administration – Part 2
HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act affects the day-to-day responsibilities of database administrators.
2018-11-01
2,480 reads
SQL Server 2019 is Here
On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to improve performance, integrate your increasing volumes of corporate data, beef up security, and more.
2018-10-30
4,429 reads
Blogs
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
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