SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /30 May 2015 at 3:52am / SQL Server

What is the SQL Server 2016 Query Data Store?

Query Data Store in SQL Server 2016 is intended as a service that monitors and optimizes query plans with full history of query execution. Query Data Store can help diagnose performance problems that are related to plan changes. What it does: Stores the...
66 0 /
Marlon Ribunal
Follow /29 May 2015 at 9:23pm / SQL Server

Finding gaps in or missing dates using TSQL

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all...
67 0 /
Chris Shaw
Follow /29 May 2015 at 3:25pm / SQL Server

Tip # 7 – Disaster Recovery Plans – Top 10 Tips for SQL Server Performance and Resiliency

This article is part 7 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. Most common mistake #7: Disaster Recovery Plans Often people hear disaster recovery...
83 0 /
Follow /29 May 2015 at 2:30pm / SQL Server

005 – Antiques Roadshow - WaterOx Consulting

Reading Time: 4 minutes Are You Running An Antiques Roadshow? In WOxPod!, episode # 005 –... The post 005 – Antiques Roadshow appeared first on WaterOx Consulting .
77 0 /
Follow /29 May 2015 at 12:33pm / SQL Server

Using OFFSET and FETCH with the ORDER BY clause

In this article we explore the OFFSET and FETCH clauses.  OFFSET and FETCH are used in conjunction with the SELECT statement ORDER BY clause to provide a means to retrieve a range of records.  The starting row to return is determined by the OFFSET value...
86 0 /
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...
133 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...
107 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...
129 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...
95 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
121 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...
120 0 /
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...
101 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...
102 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 .
107 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...
112 0 /