SQL Server

SQL Server Community

SQL Server Blogs

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...
44 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....
19 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...
47 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...
60 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...
77 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...
77 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...
173 0 /
James Serra
Follow /4 May 2015 at 8:13pm / SQL Server

TechEd is now Microsoft Ignite

In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously individual events – the Management Summit, the Exchange, SharePoint, Lync, Project, and TechEd conferences – and then taking...
73 0 /
Jason Strate
Follow /4 May 2015 at 4:00pm / SQL Server

Monday Morning SQL Break – May 4, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform technology and career related information...
82 0 /
Kenneth Fisher
Follow /4 May 2015 at 1:00pm / SQL Server

Building a job to monitor other jobs

The other day Tom Roush ( b / t ) and Tim Radney ( b / t ) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express then this may be...
88 0 /
Mladen Prajdic
Follow /4 May 2015 at 2:00am / SQL Server

SSMS Tools Pack is out with a NEW feature, a few improved features and various bug fixes.

The new feature is called Global Replacement Texts . It gives you the ability to add custom replacement texts to your scripts in four different features. Licensing now gives you the ability to upgrade your existing license from the previous major version...
81 0 /
Dinesh Asanka
Follow /2 May 2015 at 7:46am / SQL Server

Which relational DBMS is best for your company?

There are lot of databases around you. What should I select from them. Lot of parameters you need to think. Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization...
107 0 /
Jen McCown
Follow /1 May 2015 at 1:08pm / SQL Server

Announcing Minion Enterprise: the new SQL Server Management Solution

A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database...
117 0 /
Dinesh Asanka
Follow /30 Apr 2015 at 1:56pm / SQL Server

Microsoft Introduces Azure SQL Data Warehouse

Microsoft today announced a new service in its Azure database lineup during its Build developer conference keynote today. The Azure SQL Data Warehouse, which will go into public preview in June, is meant to give businesses access to an elastic petabyte...
124 0 /
Chris Webb
Follow /30 Apr 2015 at 11:09am / SQL Server

Using Function.InvokeAfter() In Power Query

Last year I blogged about how to introduce a delay between web service requests in M code. Since then a new function has been added to Power Query which makes this a lot easier: Function.InvokeAfter(). This function doesn’t seem to be documented anywhere...
96 0 /