Administration

SQLServerCentral Article

How to (Somewhat) Increase SQL Server Security

  • Article

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, […]

5 (4)

2022-01-03

6,706 reads

Technical Article

SQL Server instance startup type check by SQL script

  • Script

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 […]

5 (1)

2021-12-24

857 reads

SQLServerCentral Article

SQL Server Data Classification Comes Alive

  • Article

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 […]

5 (1)

2021-12-10

3,592 reads

Technical Article

Get backup folder sizes from shared Location

  • Script

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

Blogs

SQL Homework – July 2022 – Update your resume.

By

Resumes have been on my mind a lot recently. I’ve been thinking that I...

A Blogging Break

By

Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...

Daily Coping 5 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Designing a table

By Johnson330

Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...

Multiple Fact Tables

By yrstruly

Please assist? I would like to do a data model of the tables here:...

Drop database on Secondary Node from Primary for automatic restore job

By dennis.miller 20021

hi all We've ventured into the world of AAG's as we have now moved...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers