In the previous post I talked about what Microsoft SQL Server programming language (T-SQL) is about. I also explained what a table is and what basic information is requires. In this […]
Part 1:- Learning T SQL for beginners- SQL, Tables and Nulls
Learning SQL is easy when you have a good understanding of the basics. Everything else is based on the basics and it’s been the same since RDBMS (relational […]
Query to find execution time of Jobs
Recently we have been facing couple of issues with regard to the way the jobs have been scheduled. To investigate this, we needed a query that can identify the execution […]
A simple script to decapitalize Column names
The below script can take column names for all tables in the database and provide the rename script to only capitalize the first letter. Sometimes we just want […]
Simple Function to capitalize a string
Recently I was required to write a function that would capitalize the 1st letter in every word. This is a fairly common requirement and I felt that there […]
Boolean Hell – Missed rows when grouping in SQL
I was recently asked about the concept of Boolean hell and thought it would be a good post to discuss. Most database professionals should be familiar with the […]
What is the role of the DBA in a Cloudy world?
What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions and […]
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Database in Suspect: – DBCC CHECKDB – It has been marked suspect by recovery
A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why […]