As database administrators, we are constantly quizzed by our superiors to answer questions such as: how secure is our network, how secure is our data, is data secure at rest, is data secure in transition, who is accessing my data? All these are basic yet compelling queries businesses ask. In this age of competitive businesses, organizations are becoming tech savvy in building a secure fort for their critical data. Having worked on many projects in the past, these security measures are something I know are non-negotiable from an implementation point of view for administrators. When on this topic, I am reminded of a conversation about SQL Compliance Manager, I had with a junior DBA named Siva.
SQL Authority News – Embarcadero DB PowerStudio Promotion & Savings
If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special saving for up to 51% when you buy the DB PowerStudio bundle. With…
Read MoreSQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2
Yesterday I wrote a blog post about SQL SERVER – How to Flip Value of Bit Field in SQL Server? . Lots of good suggestions I have received in response of the same. Here are a few different methods to flip value of a bit field suggested by my very…
Read MoreSQL SERVER – How to Flip Value of Bit Field in SQL Server?
How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. Bit field can hold two different values zero (0) and one (1).…
Read MoreSQL SERVER – Database Stuck in Restoring State
Here is a one of the very common question I keep on getting via email. “I just restored all the backup files of my database, however, my database is still stuck in restoring state. How do I fix it?” Well, if you have already restored all the database, you can…
Read MoreSQL SERVER – The Why of BIML – Notes from the Field #051
[Note from Pinal]: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it. If you have been reading this blog, when it is…
Read MoreSQL SERVER – Search Records with Single Quotes – SQL in Sixty Seconds #075
Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here. Search Records with Single Quotes Search Records with Single Quotes – Part 2 Though I had clarified that all the methods displayed in these two blog posts have the exact same…
Read MoreSQL SERVER – Search Records with Single Quotes – Part 2
Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER – Search Records with Single Quotes. Here are a few other alternatives which I received as a comment. The question was how to search records with single quotes in…
Read MoreSQL SERVER – Search Records with Single Quotes
Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. How do I search records with single quotes in it? Here is the answer to find records with single quotes in…
Read MoreSQL SERVER – Combined Multiple .SQL files into One Single File
Here is an interesting problem which I enjoyed solving yesterday. There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. My friend who was…
Read More


