Me, myself and Powershell
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
3 SQL Join Concepts to Help You Choose the Right Join
What do SQL joins and the "teach a man to fish" Chinese proverb have in common? SQL joins, like regular expressions, are one of those commonplace programming tasks in which true success is entirely dependent upon your ability to conceptualize the outcome. Fail to do so and you'll likely wind up spending a few hours in a frustrating round of trial and error. Like regular expressions, the proliferation of online examples has actually contributed to the frustration, providing the equivalent of a day's worth of fish rather than the proverbial fishing pool.
Automatically Scripting Out Permissions for Cross Environment Restores
This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.
Not having TDE in all editions is stupid
Transparent Data Encryption is only available in Enterprise Edition and above. Steve Jones thinks that's a mistake.
Bringing Alerts and Operators together with Notifications
FatherJack shows you how to check that your alerts and notifications are linked up so that when an Alert condition is met that you get the appropriate Notifications sent to Operators.
A Welcome Intruder
This Friday Steve Jones asked about penetration testing of your security. Have any of you ever tested your systems?
Extra, Extras - Level 7 in the Stairway to Reporting Services
This article highlights each of the additional items needed to create a clean but beautiful report. Using the simple items of headers and footers, textboxes, and other layout options will increase the readability and manageability of your reports.
Announcing Red Gate SQL Test
SQL Test is a new unit testing plug-in which allows you to seamlessly write, run and manage tests within SQL Server Management Studio. Download the preview release now.
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers