2022-03-14
513 reads
2022-03-14
513 reads
2022-02-14
461 reads
2022-02-09
491 reads
2022-01-22
56 reads
2022-01-19
335 reads
Problem Some time ago Argenis Fernandez(@DBArgenis) found and described a vulnerability that allows you to get into SQL Server with 'sa' rights. This method does not require a restart of the SQL Server service or the whole machine, the condition is a local administrator account on the server. Reminder SQL Server until 2008R2: Until SQL 2008R2, […]
2022-01-03
6,706 reads
I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]
2021-12-24
857 reads
We will see databases deployed on the edge, and we will need strong security patches.
2021-12-20
158 reads
Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns with labels, indicating that these columns contain sensitive or special-handling data. For instance, you may want to mark a column containing credit card numbers as "confidential", or sales numbers as "management only". The problem is that you […]
2021-12-10
3,592 reads
Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]
2021-12-03
214 reads
Resumes have been on my mind a lot recently. I’ve been thinking that I...
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...
Please assist? I would like to do a data model of the tables here:...
hi all We've ventured into the world of AAG's as we have now moved...