SQL Tips and Tricks Archives - Page 239 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013

January 22, 2013

Last week, I had great pleasure to present at SharePoint Conference Singapore . It was my second time visit to this event and I had a great time attending this event. The event had more than 900 attendees and it was moved to bigger and better location since the last time.…

SQL SERVER – Best Practices to Store the SQL Server Backups

January 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Nobody doubts the necessity to create SQL Server backups – I have covered this topic extensively before. The question of where to store the backups however often goes unanswered. I will try to compare some of the most popular options for this task. For demonstration purposes we will use the…

SQLAuthority News – Download Whitepaper – Introducing the BI Semantic Model in Microsoft SQL Server 2012

January 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

IT industry has recognized that businesses benefit from a model layer over their data sources. Model layers can deliver high-performance query responses even over extremely large volumes of data, and they can encapsulate business rules and effectively secure access to data. The BI Semantic Model is a single model that…

SQL SERVER – Weekly Series – Memory Lane – #012

January 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

January 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

This is the fourth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier three parts. On my production server I personally use embarcadero DB Optimizer for all…

SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video

January 16, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Let me start this blog post with negative note: SQL Server is not mass mailing software. If you are thinking of sending emails using SQL Server instead of your mail server – I suggest you stop doing that NOW! Whenever, I see any application using SQL Server as a mail…

SQLAuthority News – Attending SQLskills Training in February 2013

January 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

If you read my resolutions blog post, you know that one of my dreams is to learn more, and specifically to attend a SQL Server class. Paul Randal and Kimberly Tripp, along with fantastic people like Jonathan, Glenn, Erin and Joe, runs amazing organization SQLskills. It is one of the…