Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
I Read Quite a Bit
Today Grant talks about the challenges of sometimes finding good, current information.
Allowing for manual checks and changes during database deployments
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
Heaps in SQL Server: Part 1 The Basics
Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of heaps so that you can determine when heaps are the best choice.
What is Azure SQL Database Serverless?
I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]
Are You a Gatekeeper?
One of the problems that I've seen in many parts of life is the belief that things must proceed a certain way. I caught an article on ways teachers have made school less fun for kids because they adhered to some rule or belief too tightly. I think many of those stories are true because […]
Migrating SQL Server Reporting Services
Learn how to migrate SSRS by following a walk through of migrating SSRS 2014 to SSRS 2016.
The Database Development Stage
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them.
Why Organizations Need to Pay Attention to Cloud Security
As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article, Vasanth Makam explains what companies need to know to make sure their data is secure.
Lock Scenarios Using sys.dm_tran_locks
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
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...
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