Category: Homepage

  • AWS: Error! RequestThrottled HTTP Status 503: Service Unavailable

    AWS: Error! RequestThrottled  HTTP Status 503: Service Unavailable

    Error! RequestThrottled HTTP Status 503: Service Unavailable AWS Access Key ID: XXXXXXXXXXXXXX. You are submitting requests too quickly. Please retry your requests at a slower rate. Recently, while trying to hit Amazon Affiliate APIs (PA API), I started seeing this error message. This error has nothing to do with DBA Stuff but I thought of…

  • STEPS TO RESOLVE MICROSOFT SQL SERVER ERROR 18456

    STEPS TO RESOLVE MICROSOFT SQL SERVER ERROR 18456

    SQL (Structured Query Language) is basically a specific domain language, which is used in programming. It is designed for the process of Data Management in the RDBMS (Relational Database Management System) in addition to this, it can also be used in the RDBMS for stream processing. SQL is a popularly used language, however, sometimes it…

  • March 2017 – DBA Things blogging contest

    March 2017 – DBA Things blogging contest

    DBA Things Team believes in bringing something new all the time. We had set the trend of “Free SQL server training” with in our community, our “March towards SQL Server : SQL Server interview question and answer series” was a super hit series. Now we are back with our first blogging contest. Idea is very…

  • Interesting Query

    Interesting Query

    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 id row then 10th id row after this other rows- I tried few queries, Hope this will help you too- Solution1 : select * from…

  • SQL Server Features

    SQL Server Features

    Sql Server 2000 : Version 8 Query analyzer & enterprise manager are separate We can create 65535 databases only Datetime datatype used for both date & time Sql Server 2005 : Version 9 Query analyzer & enterprise manager are combined as SSMS XML datatype is introduced We can create max (2^20-1) databases Ranking functions (Row_Number,…

  • A simple question for you on T-Sql

    A simple question for you on T-Sql

    Hi guys, Today i have a simple question for you & my question is what would be the result of the query- USE tempdb GO CREATE TABLE #Employee (EmpId INT, NAME VARCHAR(15), Salary INT, Expenses VARCHAR(5)) INSERT INTO #Employee SELECT 1056, ‘Viraj’, 230000, 5216 UNION SELECT 2095, ‘Dheeraj’, 98000, 7892 UNION SELECT 7258, ‘Raman’, 42000,…

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

    Experiment With Nth Highest Or Lowest Salary Or Record in Sql

    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 employees have same salary. I am asking this because in an organization few people have same salary structure. Lets understand this with an example- –Create a table and fill…

  • BigData Really…

    BigData Really…

    Hi guys, I was thinking since a long time to write blogs on big data. So, it is my first blog on BIGDATA. As a DBA, I always think where will I be after 5 years or 10 years from now. Should I be a DBA or move to BigData. You may think the same.…

  • Introduction to Windows PowerShell (Part3)

    Introduction to Windows PowerShell (Part3)

    Hi guys, I am sorry for late due to busy work schedule. But now i am here to fulfill my promise – Today we will discuss about PowerShell scripts & there execution- If you are new to PowerShell Please read previous blogs- Introduction to Windows PowerShell (Part 1) Introduction to Windows PowerShell (Part 2) Lets…

  • Introduction to Windows PowerShell (Part2)

    Introduction to Windows PowerShell (Part2)

    In this session, We will learn how you can control the result or output of command prompt & will also learn few more commands- If you are new to PowerShell, Please read previous blog Introduction to Windows PowerShell (Part1) You can start from command prompt or from PowerShell- Now Control the result of cmd prompt-  …

  • Introduction to Windows PowerShell (Part1)

    Introduction to Windows PowerShell (Part1)

    Windows PowerShell is a configuration management framework to perform administrative tasks.This tool is developed by Microsoft & available from 2006.This is one of the best tool for SQL DBA’s.It is a command line shell and associated scripting language. There are so many sites availabe giving knowledge on powershell, I will not go on theory part.…

  • SQL Server Setup Discovery Reports & Related Queries

    SQL Server Setup Discovery Reports & Related Queries

    Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances installed on the server, what is the version, the instance belong to which edition, how many features are enabled for that instance, whether it is clustered or not.…

  • Misleading Message: DBCC execution completed. If DBCC printed error messages, contact your system administrator

    Misleading Message:  DBCC execution completed. If DBCC printed error messages, contact your system administrator

    Hello Reader, Recently, it was encountered that one of the jobs which was running fine since ages has started failing with below error message. Message : Executed as user: Domain\MSSQLServer. DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022). The step failed. So,…

  • March towards SQL Server : Interview Question & Answer series

    March towards SQL Server : Interview Question & Answer series

    March towards SQL Server. This is a series of interview questions & answers on a new topic every day for SQL DBAs. Special thanks to Parvinder Pal for his enormous efforts for SQL Community. Stay tuned for whole month. One Blog Daily! Casino welcome bonus rankings 2019 bonushitlist.com: we rank the top 100 online casino…

  • Learning WordPress

    While I was migrating site from Google Site to WordPress, I learn lot about this CMS WordPress. I really loved this tool. This is so amazing and intuitive. It takes minutes to create a full working professionally looking website. I will be more than happy to share my WordPress Knowledge if someone wants to.