Microsoft Cloud OS Roadshow-Gurgaon | 22-Feb-2014

This February MS is organizing Cloud OS Roadshows and I’ve got a chance to be a speaker in Microsoft Cloud OS Roadshow which is happening on 22nd Feb’14 in Gurgaon.

I’ll be sharing the stage with two amazing speakers and MVPs: Gaurav Mantri (Microsoft Azure MVP) and Shantanu Kaushik (Windows Expert IT Pro MVP)

Join this exciting full day event to learn:

  • Breakthrough Data Performance Platform
  • Virtualization
  • Building Modern Apps and Windows Azure
  • Introduction to Cloud Computing and Windows Azure Overview
  • Windows Azure Compute – IaaS, Websites and Cloud Services
  • Windows Azure Storage – SQL Database, Blob Storage, Table Storage

Lunch will be provided.

Register today: http://bit.ly/KkS1cL

MS Cloud OS Roadshow - Infopage- sarabpreet singh anand

Cheers!

 

Update: Covered by a few bloggers: https://plus.google.com/+DronacharyaInfo/posts/XHxSzkUDRK8

SQLServer Day 11th January 2014 | Gurgaon

Hi Friends,

SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are going to cover both Dev and ITPro Audience with two different topics. This is yet another opportunity to learn.

The Sessions are Optimizing from the Field: Parallelism and SQL Server Separation of Duties – Security redefined. Events are hosted at Microsoft premises in Gurgaon so that your experience is fabulous.

Register Fast and block your seat. It is absolutely free. Also forward this email to your friends and colleagues to spread awareness.

Note: The event will start sharp at 10.00 am. Please come by 9.30 am for registration. (Due to security policies, registration takes time. Please come with a valid photo ID and the ticket print) and Refreshments will be served

To Register visit: http://www.eventbrite.com/e/sql-server-day-january-11-2014-saturday-at-microsoft-gurgaon-tickets-10041425173

Sarabpreet Singh Anand SQLServerDay 11 January 2014 gurgaon

See you at the event!

MVP Community Day \ PowerShell Day 9th Nov’2013 | Gurgaon

Dear Friends,Community_Day_9_nov_2013_Sarab

This Saturday (9th Nov’2013) South East Asia MVP Community is celebrating MVP Community Day, a day dedicated to Knowledge sharing & Learning.

 

On this very day New Delhi PowerShell User Group is organizing an event in Gurgaon, and luckily my session “Managing SQL Server using PowerShell” has been selected. Aman Dhally (PowerShell MVP) is also taking a session on Managing Event Logs using PowerShell.

This session is for all those who want to learn PowerShell and want to know more about its integration with Event Logs etc. Please use the below link to register for the event.

Register here : https://www.eventbrite.ie/event/9156263631

Session Details
Time Session Topic Presenter
9:30 – 10 AM Start of Registrations  
10  – 11 AM Managing SQL Server using PowerShell Sarabpreet Singh Anand
(
MVP SQL)
11 -11:15 AM Tea Break  
11:15 – 12:15 PM Managing Windows Event Logs using PowerShell Aman Dhally
(
MVP PowerShell)

 

See you at the event.

Regards
Sarabpreet Singh Anand & Aman Dhally
http://newdelhipowershellusergroup.blogspot.in/

SQLServer Day 26th October 2013 | Gurgaon | Bangalore | Hyderabad

Hi Friends,

SQLServerGeeks.com is planning a multi city SQLServerDay, Yes – This time on 26th October 2013 we are doing Free SQLServerDay in three cities in India: Bangalore, Gurgaon and Hyderabad.

We bring you 6 rock star speakers and 6 intriguing sessions. This is yet another opportunity to learn maximum from SQLServerGeeks.com across India. Sessions are spread across Business Intelligence, Developer & DBA tracks, so there is something for everyone to come and learn. Events are hosted at Microsoft premises in respective cities so that your experience is fabulous. Register Fast and block your seat. It is absolutely free. Also forward this email to your friends and colleagues to spread awareness. (For clarifications, please write to mamita<at>peoplewareindia<dot>com) ! [ Note: The event is strictly for working professionals]

Note: The event will start sharp at 10.00 am. Please come by 9.30 am for registration. (Due to security policies, registration takes time. Please come with a valid photo ID and the ticket print) and Refreshments will be served

Incase you want to attend any of these events you need to register (registration is free for all)

Gurgaon –> Microsoft Corporation (I) Pvt. Ltd.
DLF Cyber Greens
9th Floor, Tower A,
DLF Cyber City, Sector 25A
Gurgaon – 122002
(Near Shankar Chowk) October 26, 2013 (Saturday)
9.30 am to 1.00 pm                                                      Register Now

Hyderabad –> Microsoft India PVT LTD,
AG-MPR-001 (96) VTC, Building – 3, Survey No 210, Microsoft Campus, Manikonda Jagir, Gachibowli, Hyderabad – 500032 October 26, 2013 (Saturday)
9.30 am to 1.00 pm                                                      Register Now

 

Bangalore –> Microsoft Corporation,
4th Floor, Hamilton Hall, Signature Building,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Domlur, Bangalore – 560071 October 26, 2013 (Saturday)
9.30 am to 1.00 pm                                                      Register Now

To know more, refer the attached Image.

sqlserver-day-26-oct-2013-3-cities-India-Sarabpreet

Thanks.

Find Users with DBOwner Database role

Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted on Tier 1 Servers. Giving this information was Very easy for few servers where the DBCount was around 10 to 20, but we also have 8 SharePoint servers each hosting 200-350 DBs. Extracting this information on all these Servers was a pain, to ease things I created a script which can get all this information on a single execution.

This script can help you to extract the list of users from all databases who have DBOwner role. Once you execute the query you’ll get three column output for the query, three columns are: Database_Name, Role_Name, DBUser_Name. All the column names are self-explanatory.

You can download the script from this link: Find_DBOwners_from_All_Databases.sql

This is how the output will look like:

Find_DBOwner_all_Dbs

 

Note: Tested successfully on SQL Server 2012.

Enjoy!
Happy Learning 🙂

Thanks,
Sarabpreet Singh Anand
Subscribe now to get latest Tips\blog posts in your Inbox

Check Database consistency at-least once every month.

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit.

Transaction Log files cannot take advantage of Instant File Initialization.