SQL Server

SQL Server Community

SQL Server Blogs

Chris Webb
Follow /18 Sep 2014 at 9:17pm / SQL Server

Handling Data Source Errors In Power Query

Recently I was asked an interesting question by Ondra Plánička in the comments of a blog post : how can you handle errors caused by unavailable or missing data sources in Power Query? Let’s imagine you are loading a csv file like this one into Excel...
8 0 /
SQLDBAPros
Follow /18 Sep 2014 at 3:58pm / SQL Server

Tips for First-Timers Attending PASS Summit 2014

Are you attending PASS Summit 2014 ? If this is your first year at the conference and you’re not sure what to expect, then you are in luck! We are taking the stress and hard work out of conference prep with a simple snap shot of what you need to...
21 0 /
WaterOx
Follow /18 Sep 2014 at 3:45pm / SQL Server

Video: Walk & Talk #002 – RTO

Recovery Time Objective (RTO) What is it and why does it matter? I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server. Location: American Chestnut Land Trust –...
16 0 /
David Dye
Follow /18 Sep 2014 at 2:35pm / SQL Server

TRUNCATE or DELETE a Table?

A common question is what is the difference between truncating a table and deleting a table.  The short answer is that they both do the same thing, but in different ways.  So consider that you have a table that contains 1,000,000 rows and you need to...
23 0 /
Chris Yates
Follow /18 Sep 2014 at 1:17pm / SQL Server

Passwords – A T-SQL Tuesday Topic

Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you by Sebastian Meine Blog | Twitter . Although the time frame has passed I would be amiss if I didn’t continue on my journey...
19 0 /
Larry Leonard
Follow /17 Sep 2014 at 7:08pm / SQL Server

CMS: List All Jobs that Do Not Notify on Failure

Using CMS , we can get a list of all the Jobs on all the servers that have no email (nor page, nor netsend) notification set up for Failure. This can be useful to find Jobs that are silently failing, and even Jobs that are no longer in use. -- Find Jobs...
47 0 /
Larry Leonard
Follow /17 Sep 2014 at 6:22pm / SQL Server

CMS: List Jobs not Writing to the Windows Event Log

Using CMS , we can get a list of all the SQL Agent Jobs that aren't writing to the Windows Event Log upon failure, and set them to do so. -- Check for Jobs that aren't writing to the Event Log. declare @JobName sysname -- 0 - Never -- 1 ...
25 0 /
David Dye
Follow /17 Sep 2014 at 6:13pm / SQL Server

Why is My Log File so Big??

This is probably one of the most common posts that I see on the MSDN forums and hear from students.  The most common answer is that the database has been set to full or bulk logged recovery model and a transaction log backup has not been completed.  So...
26 0 /
Ayman El-Ghazali
Follow /17 Sep 2014 at 3:44pm / SQL Server

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools...
50 0 /
SQLDBAPros
Follow /17 Sep 2014 at 3:41pm / SQL Server

There Ain’t No Cure for the Summertime Blues, but 85 Percent Faster Backups Would Help – Case Study

“Oh, no thanks, Boss. I’d much rather sit here all summer and keep an eye on our SQL Server backups than go to the beach or ride my bike.” Said nobody. Ever. We recently published a blog about having a panic-free summer by getting...
35 0 /
Adam Kreul
Follow /17 Sep 2014 at 2:10pm / SQL Server

Why I’m Not Excited About Hekaton (In-Memory OLTP)

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some...
37 0 /
Kenneth Fisher
Follow /17 Sep 2014 at 1:00pm / SQL Server

Triggers are not toys!

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL triggers . I’m talking about plain old ordinary DML triggers . Triggers are very useful tools but can easily cause all sorts of...
41 0 /
Pradeep Adiga
Follow /17 Sep 2014 at 12:35pm / SQL Server

Application timing out due to excessive blocking on tempdb PFS

Problem Applications Connecting to SQL Server timing out Symptoms Excessive blocking with the wait resource being tempdb PFS page High CPU utilization on the server Troubleshooting sys.dm_exec_requests reported blocking and the head blocker...
38 0 /
Rohit Garg
Follow /17 Sep 2014 at 10:24am / SQL Server

Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !

The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
47 0 /
Rohit Garg
Follow /17 Sep 2014 at 10:20am / SQL Server

Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !

The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing...
60 0 /