SQL Server

SQL Server Community

SQL Server Blogs

Melissa Coates
Follow /28 Apr 2015 at 1:44am / SQL Server

Filtering in Power Query

Last week I was teaching a Power BI Workshop . On the final day while attendees were building their own solutions, one participant named Linda says to me: "Melissa, Power Pivot is missing some data." We proceeded to trace back through her Power...
67 0 /
Ed Elliott
Follow /27 Apr 2015 at 11:10pm / SQL Server

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way. Manual The manual way is where you track what changes you have made and when you want to release, build...
52 0 /
Ed Elliott
Follow /27 Apr 2015 at 10:24pm / SQL Server

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is made...
52 0 /
DBAFromTheCold
Follow /27 Apr 2015 at 9:26pm / SQL Server

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored...
52 0 /
Chris Yates
Follow /27 Apr 2015 at 5:26pm / SQL Server

Perspective

It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught...
64 0 /
Michael J. Swart
Follow /27 Apr 2015 at 4:32pm / SQL Server

The Appeal Of Lightning Talks

Lightning talks are quick presentations, usually five-ten minutes long, and I really enjoy them. But it’s not (only) about indulging short-attention-span habits. Lightning talks tend to be really dense with interesting information. The speaker...
55 0 /
Jason Strate
Follow /27 Apr 2015 at 4:00pm / SQL Server

Monday Morning SQL Break – April 27, 2015

It’s been a while since I’ve posted a blog post.  After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years.  Of course, analysis paralysis and...
79 0 /
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...
65 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...
69 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...
67 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...
72 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...
98 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...
97 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...
97 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...
156 0 /