SQL Server

SQL Server Community

SQL Server Blogs

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...
11 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...
72 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...
80 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...
77 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...
100 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...
67 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...
82 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...
88 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? ...
85 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...
89 0 /
DBAFromTheCold
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...
132 0 /
Mark Broadbent
Follow /26 May 2015 at 12:44pm / SQL Server

Want to choose your own agenda? From SQLSaturday to the PASS Summit!

OK so sadly Buck can’t be with us this year, but if he could, he would tell you to join our Programme Committee! This year, SQLSaturday Cambridge is pioneering the first ever Global Programme Committee for a SQLSaturday and we want you to be part...
69 0 /
Chris Webb
Follow /25 May 2015 at 5:35pm / SQL Server

Working With International Date And Number Formats In Power Query

One problem that can really drive you crazy when working with data from text files is the many different formats that dates and numbers can be stored in around the world. For example, take a look at the contents of a tab-delimited file shown in the following...
95 0 /
Dinesh Asanka
Follow /25 May 2015 at 6:06am / SQL Server

Important Soft Skills for the Entry-Level Data Professional

Nice article about soft skills. Read more at http://sqlmag.com/database-administration/important-soft-skills-entry-level-data-professional http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
132 0 /
Rohit Garg
Follow /25 May 2015 at 3:56am / SQL Server

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

The 16th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 16 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
115 0 /