Foundational Material: Microsoft SQL Server Book and Blogs From The Past
Erik Darling dusts off his favorite archival-quality bloggers and books.
2018-09-07
2,958 reads
Additional Articles
Introduction to Testing Your PowerShell Code with Pester
Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.
2018-09-06
2,813 reads
Using MERGE in SQL Server to insert, update and delete at the same time
In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.
2018-09-05
4,948 reads
Modern Data Warehouse Design Pattern – Part I
The modern data warehouse design helps in building a hub for all types of data to initiate integrated and transformative solutions. To achieve these goals and to support modern designs, Microsoft has introduced a set of fully managed, cloud-based services that not only support modern data warehouse design patterns but also provide the advantages of inbuilt scalability, high availability, good performance, and flexibility.
2018-09-04
3,797 reads
Introduction to HIPAA and SOX
Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is handled are nothing new. In this article, Robert Sheldon provides an overview of two US regulations, HIPAA and SOX, and explains how these regulations affect DBAs.
2018-09-03
2,620 reads
A Presenter’s Guide to the Stack Overflow Database
Brent shows you how the table joins work and points out some neat data distribution issues.
2018-08-31
2,766 reads
Introduction to PowerShell with SQL Server Using Invoke-SQLCMD
PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.
2018-08-30
3,780 reads
Handling error converting data type varchar to numeric in SQL Server
Error converting data type varchar to numeric may occur when trying to import data that looks like numbers, but doesn't act like a number. Read how to solve this issue.
2018-08-29
3,130 reads
Azure SQL Database Business Continuity Enhancements
Marcin Policht provides an overview of a number of new features that facilitate Azure SQL Database business continuity.
2018-08-28
2,456 reads
The Crimes of Chicago: Working with Data in MongoDB
NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.
2018-08-27
3,230 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