The Development Lab
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
Writing the Correct Query is Important
Making simple mistakes in queries can have far reaching consequences.
Free Webinar – Database DevOps Demo
Learn how to extend DevOps practices to SQL Server databases in our free demo webinar on January 17th. Microsoft Data Platform MVP, Steve Jones will demonstrate how Redgate’s database automation tools plug into Git, Jenkins & Octopus Deploy. Learn how to branch and merge with SQL Source Control then automate the build and deployment of changes with DLM Automation. Register now.
Using Power BI Desktop to Visualize SQL Server Metadata
You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.
Scrubbing Personally Identifiable Information
Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.
Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster
A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.
Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
Learn how easy the new SQLServer module makes backups of SQL Server databases.
Backup Data Security
We need better security for our data, especially for our choices in managing data.
Identifying Last Night’s SQL Agent Job Failures
Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers