SQL Server DBA Classes for Job Seekers
Hi All . Good Wishes from http://rameshbabu.in/. SQL Server DBA Classes for Job Seekers is back. Demo is scheduled on 30 May 6:30 AM. Key Benefits of attending the classes You can add your own content you like.click here to add All Real time issue are covered.15 issues are confirm .you can share your exp […]
PowerShell for SQL Server DBA
Loading…
Powershell Demo CLass
Easy Index suggestion
DECLARE @DBID INT SELECT @DBID = DB_ID() SELECT OBJECT_NAME([OBJECT_ID]) ‘TABLE NAME’,INDEX_TYPE_DESC ‘INDEX TYPE’,IND.[NAME],CASE WHEN AVG_FRAGMENTATION_IN_PERCENT <30 THEN ‘To Be Re-Organized’ ELSE ‘To Be Rebuilt’ END ‘ACTION TO BE TAKEN’ ,AVG_FRAGMENTATION_IN_PERCENT ‘% FRAGMENTED’ FROM sys.dm_db_index_physical_stats(@DBID, NULL, NULL, NULL, NULL) JOIN sys.sysindexes IND ON (IND.ID =[OBJECT_ID] AND IND.INDID = INDEX_ID) WHERE AVG_FRAGMENTATION_IN_PERCENT > 0 AND DATABASE_ID = […]
Install SQL Server in Linux Server 7.3
HI All Microsoft SQL Server vNext (CTP1) – 14.0.1.246 can now be installed on Linux. I am using Google Cloud Platform to create it.you can do this using https://console.cloud.google.com. get free google cloud usage worth 300 $. I have selected Red Hat Enterprise Linux 7. It requires minimum RAM of 3.5 GB.so i have selected n1-standard-2 (2 […]
Database Mail not working with GMAIL
Before starting the blog ,i have to thank Mr.Abdul Fareed he is the man behind the blog enable database mail using the below command sp_configure ‘Database Mail XPs’,1 reconfigure with override You can configure database mail from here. After configuring database mail you have to change the Gmail setting if you are getting the below […]
Execute SQL Server Query on Multiple SQL Servers using Powershell
Hi Folks Last week i had a chat with my friend Raj. he want to execute a query on multiple SQL Server. I suggest him to create a script using CONCATENATE,But he was not satisfied with my Answer. so i decided to automate this here is the script here is the code requirements create a […]
SQL Server Installation Using Configuration File
In this installation sql server required settings are saved to a configuration file and this file is used as a parameter to install sql server. Configuration file creation is a one time job. And this is done as below Run setup.exe as attended installation(GUI) based installation select your requirement once when you are done with […]