SQL Server

SQL Server Community

SQL Server Blogs

Follow /27 May 2015 at 8:42pm / SQL Server

SQL Server 2016 CTP 2 Preview Now Available

Back in the beginning of May, Microsoft announced SQL Server 2016 and the massive amount of new features that are going to be released. Combining this with all of the Power BI enhancements and Azure enhancements that are being released, it is a great...
39 0 /
James Serra
Follow /27 May 2015 at 4:00pm / SQL Server

How an MPP appliance solution can improve your future

Massive parallel processing ( MPP ) is the future for data warehousing. So what is MPP?  SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server.  MPP provides scalability and query performance by running...
55 0 /
Follow /27 May 2015 at 3:30pm / SQL Server

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutes I had a project once that was using change data capture (CDC)... The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting .
56 0 /
Derik Hammer
Follow /27 May 2015 at 1:00pm / SQL Server

Store Optional Connection Parameters in SQL Server Management Studio

About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS . At the time, I had presented three problems and only solutions for two of them. At this time, I am happy to announce that Microsoft has responded...
65 0 /
Follow /27 May 2015 at 9:00am / SQL Server

SQL Server 2016 CTP2 now available

The official Community Technical Preview 2 (CTP2) release build for Microsoft SQL Server 2016 is available for public download here . One week ahead of schedule ! Any feedback is greatly valued and can be submitted here . Enjoy !!
5 0 /
Dinesh Asanka
Follow /27 May 2015 at 5:34am / SQL Server

Shopping Basket Analysis in SQL Server

A famous super market chain in USA once observed that men who are buying beer for weekend tend to buy nappies for their kids. This revelation enabled the chain in increase sales volume and revenue by placing the items in close proximity to each other...
84 0 /
Paul Turley
Follow /27 May 2015 at 1:46am / SQL Server

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from  recent project experience.  I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot.  I’ve...
88 0 /
Shaun Stuart
Follow /26 May 2015 at 11:22pm / SQL Server

The Certification Shuffle

Last weekend, I passed the last test needed to upgrade my MCTS: SQL Server 2008 certification to the MCSA: SQL Server 2012 certification. I still need to take one more exam to upgrade my MCITP: Database Administrator 2008 to the MCSE: Data Platform certification...
85 0 /
Paul Turley
Follow /26 May 2015 at 7:40pm / SQL Server

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article:   Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft...
121 0 /
Bob Pusateri
Follow /26 May 2015 at 6:27pm / SQL Server

Thoughts on PASS Summit Speaker Selection

It’s getting to be about that time of year again. Bees are buzzing, Summer’s nearly here (at least in the northern hemisphere), and PASS Summit 2015 session selections will probably be announced soon. I don’t know this for sure; I’m...
73 0 /
Jason Strate
Follow /26 May 2015 at 4:00pm / SQL Server

Tuesday Morning SQL Break – May 26, 2015

It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter ( @StrateSQL ). This is a good chance to catch up on data platform...
90 0 /
Dinesh Asanka
Follow /26 May 2015 at 3:31pm / SQL Server

Support for SQL Server 2005 Ends April 12, 2016

oduct expiration is a fact of life. And, no matter how much we love a product or no matter how long we cling to its familiar interface, we eventually have to give up on it. Such is the case with SQL Server 2005. SQL Server 2005 is the next in a running...
97 0 /
Kenneth Fisher
Follow /26 May 2015 at 1:00pm / SQL Server

Default database

What? The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string. How? ...
93 0 /
Gethyn Ellis
Follow /26 May 2015 at 1:00pm / SQL Server

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite Once you have created your database you can now start to manage and configure it. There are six menus for a SQL Azure Database: - Dashboard Monitor Scale Configure GEO-Replication Auditing and Security The Dashboard The Dashboard...
96 0 /
Follow /26 May 2015 at 12:54pm / SQL Server

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can download the datasheet they’ve posted from here . The features that have caught my attention are:- Enhancements to...
138 0 /