With SQL Server there are a variety of ways we have available to secure data within the databases, however if an attacker can gain access to the underlying data files we may be vulnerable to having that data interrogated. Similarly when we backup our databases these flat files could also be intercepted and restored elsewhere […]
Category: SQL Server
Following on from previous posts where we looked at Dynamic Data Masking, how to use it, and the challenges we may encounter, there’s one last area I wanted to touch on. With the arrival of SQL Server 2022 the masking functionality has been extended so we have an additional masking function and more granular permissions […]
This month’s invitation from Steve is asking about strategies for upgrades with SQL Server. We might be more familiar with patching a SQL environment semi-regularly – and those processes may be tried and trusted – however its much rarer that we have the opportunity to uplift an entire environment to a later version. Here’s a […]
Categories
Moving Database Files between Drives
So you inherit a server and find the previous owners had left the default data and log folders on the C: drive and at the same time they managed to put half your databases are on the correct drives and the others were left getting cosy with your operating system. Thankfully remediation isn’t too painful […]
Categories
Renaming Tables in SQL Server
Renaming tables, that’s easy right? Renaming a Table Performing the rename of a table is straight forward in Management Studio via Object Explorer. You can simply select the table and right click and Rename (or press F2) and edit the name right there and then. Hit return and we’re good to go. If you’re scripting […]
Recently there was a question of why a query runs under a second on one environment and another environment runs the same query for 90 seconds and times out the application. It was observed the memory on the second system was running at 94% and so it was put down to that and ‘get more […]
Categories
Tidying up the SSIS Database
If we’re running SQL Server Integration Services (SSIS) then it’s database is the wonderful place where we store our packages ready for execution and the lovely logs we can interrogate when those packages inevitably break (of course not, our code is perfect, right?) This database is all well and good in a fresh environment however […]
Andy Brownsword 