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

Leave a reply

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.

Cheers!

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

SQLServer Day 11th January 2014 | Gurgaon

Leave a reply

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

See you at the event!

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

Leave a reply

Dear Friends,

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.

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

Leave a reply

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]

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.

Thanks.

Find Users with DBOwner Database role

Leave a reply

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:

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
Follow @SQLDB

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.

SQL Tip-9 | Track the Original Login–even if the Execution Context is switched

Leave a reply

Few months ago I started a series where I explained all about Execution Context & Context switching, you can use Execution context switching for many reasons but if you are auditing execution context can leave all your auditing meaningless.

You’ve to plan in advance for such Execution context switching and the below mentioned Function can help you identify the Original login even if the context has been switched. Smile

Select Original_Login()

This function will help you get the name of the login that connected to the instance of SQL Server. You can use this function to return the identity of the original login in sessions in which there are many explicit or implicit context switches.

There is a saying A picture is worth a thousand words, So here is the screenshot which can help you understand this better Winking smile

Hope it is now clear, feel free to leave a comment. 🙂

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

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts:

Liked it? Go ahead and Share:

Related posts: