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?
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.
Working with the XML Data Type in SQL Server
The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful extensions to SQL Server. Robert Sheldon, in the first part of a series, describes how create and index a XML column in a table, and discusses when you should consider using an XML data type.
Fast Migrations
Virtualization is an important technology for anyone working with servers, and as vendors look to improve the performance of their hypervisors, this technology might be more important for data professionals to understand.
Mind mapping software - How it can help the DBA
Mind mapping software allows the rapid capture of thoughts and ideas. It is a killer app that can easily help a busy DBA capture their thoughts
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers