Upsizing the SQL ConstantCare® Database Servers
If you’re looking for SQL Server news, just skip this post. Brent talks about general business & capacity planning type stuff here today.
2020-01-01
Additional Articles
SQL Server Create Database Examples
In this article we look at different T-SQL examples to create a new SQL Server database.
2019-12-31
Quickly Find and Mask Sensitive Data with Data Masker 6.3.1
Khie Biggs, a software developer on the Data Masker team at Redgate, explains how a recent set of Data Masker improvements should make it significantly easier and faster both to determine what data needs to be masked, and then to apply the masking, to protect sensitive and personal data in the tables and columns of your SQL Server databases.
2019-12-30
Storage 101: Welcome to the Wonderful World of Storage
Understanding all the storage options available to...
2019-12-30
Do You Have REFERENCES?
The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.
2019-12-27
ASP.NET Core with GitOps: Deploying Infrastructure as Code
Automation of server builds minimizes human error, ensures that environments are identical, and saves time building servers. This article from Mircea Opera demonstrates provisioning one server or multiple load-balanced servers in AWS with code.
2019-12-26
SQL Server Transparent Data Encryption vs. NetLib Encryptionizer
Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry. SQL Server ships with a few options for a native encryption implementation (Column Level Encryption, Transparent Data Encryption, Data Masking, Always Encrypted), that all provide value in particular situations, but none of the options all seem to address all of the needs. What is the best way to encrypt our SQL Server data?
2019-12-26
Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
2019-12-25
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-24
How to Restore Model Database in SQL Server
In this tip we look at how to restore a missing or corrupt SQL Server model database.
2019-12-23
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers