Scripts | DBA THINGS
Category: Scripts
0
Script : Disable all non sysadmin logins
0

buy generic Finax 1mg Hello Reader, I am sharing a quick script to disable all non sysadmin logins for SQL Server. You can not disable windows groups so I tweaked this script to ...

0
Interesting Query
0

http://vipluxsalon.com/contact/ Hi Guys! Today one of trainee in my team asked me one strange question, he shows a table and data - Then he asked me to get first 7th id row then 15th ...

0
Experiment With Nth Highest Or Lowest Salary Or Record in Sql
0

source site I was reading about it so i searched it on so many blogs & websites. Each blog has described this for employees having unique salaries, but what if few ...

0
SQL DBA Cheatcode : 15 Things about SQL Server Error logs
0

Today I am writing about some good facts about SQL Server Error logs.   SQL Server maintains its own error logs that contain messages describing ...

0
SQL DBA Cheatcode : SQL Server properties
0

In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. ...

0
Backup of OLAP Database using Powershell
0

In this article I would like to explain another method to take the backup of OLAP databases via PowerShell. It will help out to take the backup of multiple ...

0
PowerShell : Copy a table from one server to another
0

In general, a DBA like us gets requests to copy a table data from one SQL Server instance to another. In that case, a DBA first sees the amount of data present ...

0
Script : Who deletes the databases?
0

Hello Readers, Before starting, let me give you some background about this problem. I used to support few servers which had more than 1000 small databases. ...

0
SQL DBA Cheatcode Part 6 : Know your SQL Server
0

Hello Readers, I am here adding few more feathers to our SQL DBA Cheatcode series hat. If you have not read our others blogs of this series, you may do it ...

0
SQL DBA Cheatcode Part 5 : Playing with indexes
0

Hello Readers, Today, I am trying to put down few but very useful index related scripts. I have used these scripts many times with different versions of SQL ...

0
Proactive Monitor of System Database Files
0

Dear Readers, Today I am writing about a very common problem of Outages that are caused by system database data/log files growth. Problem: generally, ...

0
Keeping your Server Secure Part 1 : Login Password Policy
0

Dear readers,   Now we are going to cover very important activity from a DBA perspective. Database\Server Security is the one of the most important ...

0
SQL DBA Cheatcode Part 4 : Few Important Queries for any DBA
0

Dear Readers,   I am back with part 4 of Cheatcode series after gap of almost one month. In First three Parts of this series I covered, Few Generic ...

0
Script : How to find SQL Server orphan Logins?
0

Dear Readers, An attempt has been made to write a short script to find out SQL Server Orphan Logins. By the way, I am not sure if Microsoft has any term ...

0
Script : Who all have access to SQL Server via AD Groups?
0

Dear Reader, Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts ...