Last weekend I happened to be in one of the beautiful cities in Sri Lanka for some fun time with SQL Enthusiasts. We had our first ever SQLSaturday Event in Sri Lanka and it was just too much fun to be amongst the amazing audiences. I was fortunate to deliver a couple of sessions and not to forget the hours and hours of interaction with the attendees post session. In this blog post we will answer the question How Many Line of Code Do You Have in Database?
SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084
[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…
Read More
SQL SERVER – Security Auditing With ApexSQL Audit
SQL Servers and databases are probably the most critical IT parts of an enterprise. The most important and confidential data are stored there and even a potential issue with that data can be business critical. In situations where significant preventive/protective actions are applied, such measures will not be of any help in determining the cause of an incident when it occurs. For that purpose, establishing the SQL Server continuous auditing and especially being informed, timely of security configuration changes have been of the utmost importance. Let us learn about Security Auditing.
SQL SERVER – Puzzle with Year Function
A couple of weeks back, I ran a contest with MONTH () function and had close to 300 of you answer the puzzle. It was a great brain teaser and we had an awesome response from you. Most of you got the answer right and it is great to see you folks getting the basics right.
SQL SERVER – Know Your Backup Before Deleting Database
Earlier last week I wrote a blog around, SQL SERVER – FIX – Msg 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use. The premise of that blog was driven by some of the demo’s I show at conferences. During one of the UG…
Read MoreInterview Question of the Week #023 – Error Handling with TRY…CATCH
Here is one of the most popular question I see people discussing in SQL Interviews. Question – How do you handle errors with the help of TRY…CATCH? Answer – TRY/CATCH helps to write logic separate the action and error handling code. The code meant for the action is enclosed in…
Read MoreSQL SERVER – FIX: Msg 3102, Level 16, State 1 – RESTORE cannot process database ‘Name’ because it is in use by this session
Some of the simple learnings can come from unexpected places and this blog post is a classic example to that statement. Recently I got an email from one of my readers about the below error message: Msg 3102, Level 16, State 1, Line 2 RESTORE cannot process database 'DBProductDevelopment' because…
Read More
SQL SERVER – FIX – Error 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use
We learn from mistakes and we improvise with experience. I couldn’t think of a better example than the one below for this. I have been watching many sessions by various speakers and found that many times they have struggled to get rid of Error 3702.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database.…
Read MoreSQL SERVER – Finding Out Identity Column Without Using Column Name
There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note that the table test1 has identity column and table test2 does not have…
Read More