SQL Server

SQL Server Community

SQL Server Blogs

Kenneth Fisher
Follow /27 Apr 2015 at 1:00pm / SQL Server

What SQL version is my SSIS package?

When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how everyone thought DTS was much better and did they really have to switch? Over the years I’ve come to appreciate SSIS. It is a very powerful and...
5 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:20am / SQL Server

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

The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
58 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:18am / SQL Server

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

The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
58 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:15am / SQL Server

Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
59 0 /
Ed Elliott
Follow /25 Apr 2015 at 11:26am / SQL Server

Sql Saturday Talk

I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to. The slides...
91 0 /
Chris Webb
Follow /24 Apr 2015 at 10:02am / SQL Server

Analysing SSAS Extended Event Data With Power Query: Part 2, Storage Engine Activity

In part 1 of this series I showed how to use Power Query to extract Extended Event data generated by SSAS. Having done that, I now want to show the first (I hope of many) examples of how this data can be used for performance tuning: analysing activity...
87 0 /
Rohit Garg
Follow /24 Apr 2015 at 5:49am / SQL Server

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER...
91 0 /
Derik Hammer
Follow /23 Apr 2015 at 2:38pm / SQL Server

PowerShell Start-Job

The Start-Job Cmdlet is a fast and extremely simple means of spawning asynchronous threads. Why do we care? Because performing parallel work is faster and our time is important. If I want to inventory the Windows services running on every server in my...
146 0 /
WaterOx
Follow /22 Apr 2015 at 2:30pm / SQL Server

How Many SQL Log Files Do You Keep?

Reading Time: 2 minutes Ever have this happen? You (on vacation): I’ll have another piña colada please. Yes, in the coconut. Thanks! Hmm, my phone is ringing…..Hello? Work: There are problems! The database is messing up and being really...
159 0 /
sqlkris
Follow /22 Apr 2015 at 1:00pm / SQL Server

How to Write Queries – Formulate your Question – Step 2

This is the third of four articles in a series explaining the three simple steps I take to writing complex SQL statements.  The series starts with this introductory article . All the examples for this lesson are based on Microsoft SQL Server Management...
158 0 /
Kenneth Fisher
Follow /22 Apr 2015 at 12:00pm / SQL Server

Backup before you restore

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back I wrote about Operational Recovery . This is when there isn’t a disaster but you still need to restore some or all of...
108 0 /
Chris Webb
Follow /22 Apr 2015 at 3:15am / SQL Server

Power Query Announcements At The PASS BA Conference

There were a couple of big (well, big if you’re a Power Query fan like me) announcements made today by Miguel Llopis at the PASS BA Conference: Today Power Query is available only to people who have Excel Professional Plus or Excel standalone, but...
203 0 /
Ed Elliott
Follow /21 Apr 2015 at 9:28pm / SQL Server

What Permissions do I need to generate a deploy script with SSDT?

It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can...
109 0 /
sqlsanctum
Follow /21 Apr 2015 at 2:00pm / SQL Server

Monitoring Backup and Restore Times

Backups and restores are arguably the most important aspect of a DBA’s job. There are few times when a manager will be breathing down your neck more impatiently than during a restore process. Of course, one of the worst things you can say during such...
119 0 /
Gethyn Ellis
Follow /21 Apr 2015 at 11:00am / SQL Server

SQL 2014 CU5

By David Postlethwaite If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have...
128 0 /