All Articles - SQL Authority with Pinal Dave

SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

December 19, 2013

[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…

SQL SERVER – How to Survive on Free Tools for Month – ApexSQL Complete – A Free SQL Advanced Intellisense

December 18, 2013

Pinal Dave

SQL

ApexSQL, SQL Utility

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

December 17, 2013

Pinal Dave

SQL

Devart, SQL Utility

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

December 16, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Dell, SQL Utility

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…

SQL SERVER – How to Identify Datatypes and Properties of Variable

December 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…

Personal Technology – How to Dress for an Interview – Guidelines and Suggestions

December 14, 2013

Pinal Dave

SQL Tips and Tricks

If you Google “how to dress for an interview,” you will get 253,000,000 results. That is how many articles there are on the internet telling you how you should and should not dress yourself to meet potential employers – and this is not counting the innumerable books, magazine articles, and…

MySQL – How to Create Stored Procedure

December 13, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Scripts

If you are beginner with MySQL, you will face this particular issue while creating Stored Procedure. When I started with MySQL I had faced the similar situation as well. In MySQL we end every statement with semicolon. However, when we try to create stored procedure we face dilemmas that how…

SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006

December 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Notes from Pinal]: Quite often we hear that my SQL Server is taking more memory or my server needs more memory as all the applications are running slow. The reality is that no matter how much memory you have it is never going to be enough. We all want more…

SQL Reporting – How to Add Excel and Word Reporting to Your Own Application – An Innovative Approach

December 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SSRS

To experience the awesomeness of OfficeWriter, I suggest you here to download the tool and work along with this blog post. The OfficeWriter API is a .NET library by SoftArtisans that makes it easy for developers to add Excel and Word reporting and document processing to their own applications. OfficeWriter…

SQL SERVER – Working with Business Days in SQL Server – A Different Approach

December 10, 2013

Pinal Dave

SQL

Excel, SQL Scripts, SQL Server

I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.