A growing field in the information security domain – Database Forensics offers a comprehensive and highly sophisticated skill set that allows professionals to uncover and trace data security breaches of the highest order and complexity. Many enterprises are looking to hire such professionals nowadays.
SQL SERVER – Learning More About SQL Wait Stats
I was recently visiting my customer for my day job in Delhi. During the meeting, I had a great time to meet a few of the technical domain experts of the leading organization. We discussed lots of different things while we were there and much of the conversation was surrounding…
Read More
SQL SERVER – What Permissions I have on Database I am Connected to?
Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know…
Read MoreDeveloper – Nine Things Developers Hate to Hear
1. Uh oh… No one likes hearing this – not parents, not repairmen, not developers. They don’t like hearing others say it, and they don’t like hearing it come out of their own mouths. It usually means bugs. 2. Can you fix my computer? This question is the bane of…
Read MoreSQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7
This is the seventh part of a series regarding Redundant Indexes. If you have not read the earlier parts – there is quite a good chance that you will miss the context of this part. I suggest that you should quickly read the earlier four parts. On my production server…
Read MoreSQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007
[Note from Pinal]: This is a seventh episode of Notes from the Field series. The biggest issue any DBA have with their server is the health of it. We all want to configure our server optimally and know any issue with it if it faces one. This is one of…
Read More
SQL SERVER – How to Survive on Free Tools for Month – ApexSQL Complete – A Free SQL Advanced Intellisense
ApexSQL Complete is a free add-in for auto-completing SQL code which integrates with SQL Server Management Studio and Visual Studio. Let us learn about free tools for the month.
SQL Contest – USD 100 Gift Card and Attractive Discount from Devart
No matter how old we get we all want to Santa to give us gifts during the festival season. As the festival seasons has been approaching I was talking to a few of the Developer Tools vendors to see if they can come up with something cool for blog readers. If you are familiar with this blog, you must know about Devart. They are a fantastic team of people and make beautiful and easy to use tools. Let us see how to win USD 100 gift card.
SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE
Note: This review is based on the performance monitoring and tuning free product Spotlight on SQL Server Freemium. If you think of a DBA’s life, it has one very simple goal – their server should never go down and all the queries should always perform excellently. However, just like any…
Read MoreSQL SERVER – How to Identify Datatypes and Properties of Variable
Just another day I received very interesting question in email from Zovis and we exchanged few emails. I am converting our conversation in the chat format to understand it easily. Zovis: How do I identify the datatype and other properties of the variable? Pinal: Just check the datatype of the…
Read More