SQL Server

SQL Server Community

SQL Server Blogs

Follow /6 May 2015 at 6:44pm / SQL Server

Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell

If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance Solution. If you haven’t please start here https://ola.hallengren.com/ You can also watch his presentation at SQLBits at this...
57 0 /
James Serra
Follow /6 May 2015 at 6:00pm / SQL Server

Azure SQL Data Warehouse

Analytics Platform System (APS)  is Microsoft’s massively parallel processing ( MPP ) data warehouse technology.  This has only been available as an on-prem solution (see video Overview of Microsoft Analytics Platform System ).  Until now.  At the...
92 0 /
Dinesh Asanka
Follow /6 May 2015 at 5:13pm / SQL Server

Changing the SSRS Subscription Owner

When subscriptions are created, owner of that subscription will be the user who creates it. However, when that user account is disabled, subscriptions will be failed and there is no way from the user interface to change it. However these subscriptions...
63 0 /
Jason Strate
Follow /6 May 2015 at 4:00pm / SQL Server

May 2015 – SQL Server Monthly Maintenance Checklist

image source It’s time for a monthly reminder to review you SQL Server environment.  Hopefully over the last few months of this post not being published you’ve still been going through and performing your monthly SQL Server environment checklists...
58 0 /
Follow /6 May 2015 at 3:30pm / SQL Server

Identity Removal

Reading Time: 2 minutes Men In Black are not the only ones that can remove an identity Identity columns are great. they help us to understand our data better, and can even help our queries to perform better. But what if you made a mistake when creating...
62 0 /
Kenneth Fisher
Follow /6 May 2015 at 1:00pm / SQL Server

Notes on Presenting

As you may know I’m preparing to write my first presentation . I have a great abstract and an outline of the presentation itself. Next step is creating the Powerpoint slides. Then practicing the presentation itself. So while going to my latest SQL...
68 0 /
Gethyn Ellis
Follow /6 May 2015 at 1:00pm / SQL Server

Putting Your Head in the Clouds 1 – An introduction to Cloud Computing

By David Postlethwaite Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it is only relatively recently that it has matured to the point where it is no longer just an interesting curiosity but a serious...
64 0 /
Dinesh Asanka
Follow /6 May 2015 at 3:31am / SQL Server

Is your organization ready to virtualize SQL Server?

virtualization has become a hot topic. Michael Webster is one of the authors of Virtualizing SQL Server With VMware, which guides administrators in the steps required to virtualize the popular database application. One section of the book centers on how...
93 0 /
Follow /5 May 2015 at 8:09pm / SQL Server

SQL Server 2016 is coming….

Yesterday at the keynote for the Microsoft Ignite conference Satya Nadella announced the next version of SQL Server, which will be available next year and in public preview later this summer. Rather than hitting all the marketing jumbo that’s been repeated...
86 0 /
Chris Shaw
Follow /5 May 2015 at 6:43pm / SQL Server

Tip # 6 – Change History

Tip # 6 – Change History Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive....
71 0 /
Jason Strate
Follow /5 May 2015 at 5:48pm / SQL Server

Book Review: The Checklist Manifesto: How to Get Things Right

Earlier this year, my buddy Dan recommended that I read The Checklist Manifesto: How to Get Things Right .  The recommendation was actually more of a demand.  When we had been talking about my need to increase the productivity of my time, he wanted me...
66 0 /
Gethyn Ellis
Follow /5 May 2015 at 3:58pm / SQL Server

SQL Server 2016 Preview...Coming this Summer

It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With it being a bank holiday in the UK … I missed it yesterday You can read the blog post here http://blogs.technet.com/b/dataplatforminsider...
89 0 /
Chris Webb
Follow /5 May 2015 at 9:30am / SQL Server

Improving Power Query Calculation Performance With List.Buffer()

I saw an interesting post the other day on the Power Query Technet forum which showed how the List.Buffer() function could be used to improve calculation performance. This is something I’d seen hinted at in other places so I thought it was worth a bit...
91 0 /
Dinesh Asanka
Follow /5 May 2015 at 6:43am / SQL Server

SQL Server 2016 public preview coming this summer

Satya Nadella, CEO of Microsoft, announced SQL Server 2016 , an intelligent platform for a mobile first, cloud first world. The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical...
95 0 /
Paul Turley
Follow /5 May 2015 at 2:40am / SQL Server

Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free

Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite.  This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio...
295 0 /