SQL Server

SQL Server Community

SQL Server Blogs

Thomas LaRock
Follow /28 May 2015 at 9:20pm / SQL Server

42 Things You Should Never, Ever Say To a DBA

As a parent of two soon-to-be-asking-for-the-car-keys tweens, I came across this post the other day and found it struck a chord with me. I’ve gotten the eye-rolls from my daughter for everything on that list by now. My son is younger but I am certain...
0 0 /
Chris Shaw
Follow /28 May 2015 at 3:21pm / SQL Server

SQL Server Performance and Resiliency Session

You might have been following along with my recent series of posts related to a number of resiliency tips for SQL Server. I have compiled these tips based off my observations over the last 20 or so years. Over the summer I have the opportunity to present...
76 0 /
Kenneth Fisher
Follow /28 May 2015 at 1:00pm / SQL Server

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea. UserA is a member of Group1, Group2 and Group3. Group1 is set up as a server principal with a default...
63 0 /
Gethyn Ellis
Follow /28 May 2015 at 1:00pm / SQL Server

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite On the Database Scale page we can decide on the performance level that we want our database to have. There are three performance levels Basic, Standard and Premium Basic is best suited for a small size database, supporting one single...
70 0 /
Dinesh Asanka
Follow /28 May 2015 at 12:31pm / SQL Server

Microsoft Virtual Labs for SQL Server 2016

If you want have experience about SQL Server 2016, Microsoft Virtual Labs provides it for you. There are seven labs up to now. https://technet.microsoft.com/en-us/virtuallabs http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
88 0 /
Dinesh Asanka
Follow /28 May 2015 at 3:44am / SQL Server

Microsoft Releases First Public Preview of SQL Server 2016

The first public preview of Microsoft's SQL Server 2016 database is available, and testers can opt for faster, more frequent updates to it. Microsoft is making available to anyone who wants to kick the tires a first public preview release of its coming...
98 0 /
sqlbischmidt
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...
82 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...
81 0 /
WaterOx
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 .
85 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...
96 0 /
regbac
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 !!
97 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...
102 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...
110 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...
105 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...
164 0 /