The Young DBA

Friends, Till now I haven’t got chance to vote in any election for PM or CM. This month everywhere talking about elections and here I am busy with my work connect-share-discover with database and applications..  Today I want to share How to Create Read-Only User in MySQL using workbench. First Go to Users and Privileges option from Workbench Managements Tab. Click on Add account and give account name and their respective password, after that apply. In Users and Privileges box there are 2 other tabs, Administrative Roles and schema privileges. Administrative Roles is Similar to Fixed Server roles of SQL Server. Schema privileges is schema level authorization process. Select Schema privileges and click on Add Entry. Then a Dialog box will come with schema available in server. Now select any schema which privilege we have to configure. After that give the appropriate rights which we have to give. As I have selected on select. Finally click on Apply.

SQL Server 2005 introduced the unstructured data types VARCHAR (MAX), NVARCHAR (MAX) and VARBINARY (MAX). And later on File stream features came with 2008. We are using SQL Server version 2012 and unfortunately I would like to say to Microsoft doesn’t given option to attach File-stream Enabled Database from SSMS. Mostly this requires when trying to migrate DB or system or doing some DR activity or maintenance activity. If you will try to attach from SSMS then it may give some errors like below … TITLE: Microsoft SQL Server Management Studio ------------------------------ An error occurred when attaching the database(s).  Click the hyperlink in the Message column for details. ------------------------------ BUTTONS: OK ------------------------------   But don’t worry just try below query to re-attach db.. USE [master] GO CREATE DATABASE <DBNAME> ON ( FILENAME = N'LOCATION\name.mdf' ), ( FILENAME = N'Location\name.ldf&#

Impersonation is when ASP.NET executes code in the context of an authenticated and authorized client. By default, ASP.NET does not use impersonation and instead executes all code using the same user account as the ASP.NET process, which is typically the ASPNET account. There are 5 below steps by which we can establish Impersonation configuration in our secured application environment. 1.)    Creation of Application/Proxy user where Application is hosted. 2.)    Give appropriate access to the user. 3.)    Create Database Login user on database. 4.)    Authenticate User and provide credential on IIS. 5.)    Then Configure web.config on Application.

We should not expect that we required to use my backups but we should always ready for worst cases scenario either DB or IIS Server’s Configuration… In previous version IIS 6.0   we were taking Meta base (IIS Configuration) backup from GUI but later on in new version (7.0 > ) this is removed and now we are using AppCmd utility of IIS manager Service. Today i want to share about AppCmd.

When we install any SQL Server Instance, all installation log we can study through its Boot Strap folder which we can find from the PATH C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log .  Like Below

Below are two generic errors in every version of IIS. If we deploy applications without few configuration or setting in Application Pool & ISPAI Extension these errors will comes up. There are few changes in IIS 7/ IIS 8 but process are same.  After New installation of IIS and before deploying any Application I do below configuration in IIS 8/7 to remove these error.   The requested content appears to be script and will not be served by the static file handler.  or An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.

In short Page File is simply a file on the hard drive that handles situations where the system wants to move or page out sections of memory .  There are several situations that cause this, but the one you're most concerned about is when the system is out of physical memory. Tech net  Article is best to configure & monitor Paging File.

Keeping updated production environment is an important task for any DBA. Updated Database Server allows to Secured and bug free environment and it helps to keep growing organization and there business process. To updated our production environment we should know few terms related to Database server maintenance activity.   

Q:- What are the Default Services in SQL Server 2012 ? If this questions is related for Interview then this can be tricky because as per configuration manager the default services related to SQL server are 4 (DB Engine, Full text, Browser and Agent Service). To check run   compmgmt . msc  from CMD Prompt and select SQL Server Configuration Property. Then List of Services will show like below

Now I am habituated to use CTRL+R to see the code in full screen because it allows me to hide the result or message pane from windows.  Working on SSMS for Development or testing any TSQL procedures I like too much and I am using this tool since 4 years.

Error - provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe "A mountain in labour and a mouse be result" .Sometimes it happens in finding Root Couse. I faced the same when I was new in organization. Web application was throwing error something like below …

Every organization have different work environment, culture and network infrastructure. After getting place in new organization I am learning new things and comparing all those about past windows, db , application & processes . 

SQL Server Versions and Code Names :- Version Year Release Name Codename 1.0 ( OS/2 ) 1989 SQL Server 1.0 (16bit) - 1.1 ( OS/2 ) 1991 SQL Server 1.1 (16bit) - 4.21 ( WinNT ) 1993 SQL Server 4.21 SQLNT 6.0 1995 SQL Server 6.0 SQL95 6.5 1996 SQL Server 6.5 Hydra 7.0 1998 SQL Server 7.0 Sphinx - 1999 SQL Server 7.0 OLAP  Tools Plato 8.0 2000 SQL Server 2000 Shiloh 8.0 2003 SQL Server 2000 64-bit Edition Liberty 9.0 2005 SQL Server 2005 Yukon 10.0 2008 SQL Server 2008 Katmai 10.25 2010 SQL Azure DB CloudDB 10.5 2010 SQL Server 2008 R2 Kilimanjaro (aka KJ) 11.0 2012 SQL Server 2012 Denali Version with Service Packs... SQL Server 2012 11.0.2316 SQL Server 2012 CU1 12 Apr 2012 11.0.2100.6 SQL Server 2012 RTM 7 Mar 2012 SQL Server 2008 R2 10.50.2811 SQL Server 2008 R2 SP1 CU6 16 Apr 2012 10.50.2806 SQL Server 2008 R2 SP1 CU5 22 Feb 2012 10.50.2796 SQL Server 2008 R2 SP1 CU4 9 Jan 2012 10.50.2789.0 SQL Server 2008 R2 SP1 CU3 17 Oct 2011 10.50.2772.0 SQL