SQL Server

SQL Server Community

SQL Server Blogs

James Serra
Follow /1 Jul 2015 at 4:00pm / SQL Server

What is Polyglot Persistence?

Polyglot Persistence is a fancy term to mean that when storing data, it us best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.  Different kinds...
9 0 /
WaterOx
Follow /1 Jul 2015 at 3:30pm / SQL Server

Speaking at PASS Summit 2015 & SQL Live360! - WaterOx Consulting

Reading Time: 2 minutes Seattle, here we come! I am excited, and honored that it is... The post Speaking at PASS Summit 2015 & SQL Live360! appeared first on WaterOx Consulting .
29 0 /
Chris Yates
Follow /1 Jul 2015 at 1:15pm / SQL Server

SQL Saturday Field Notes

As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make your way into the building where you are ushered toward the sign in table; there is where you are greeted by more volunteers who help you get...
46 0 /
Kenneth Fisher
Follow /1 Jul 2015 at 1:00pm / SQL Server

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then you need to do the unusual. Blocking and Deadlocking are based on lock requests and locking is handled...
51 0 /
NickyvV
Follow /30 Jun 2015 at 11:02pm / SQL Server

Don't Always Blame The Data

Just a quick post on this error I received yesterday. While I was working at a client, the application manager made some changes to a Slowly Changing Dimension of type 2 with effective dates, as mentioned here . This dimension contains the organisational...
64 0 /
Ed Elliott
Follow /30 Jun 2015 at 8:00pm / SQL Server

Download SSMS, SSDT or SSDT-BI

It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing. This is an example of some frustration: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c82354d0-2f88-4......
69 0 /
Derik Hammer
Follow /30 Jun 2015 at 2:00pm / SQL Server

Writing Repeatable T-SQL

Writing code for a database is more of a challenge than writing for applications. Before the developers bite my head off, I do not mean that the languages, such as T-SQL, are more difficult or that applications are any less sophisticated than database...
88 0 /
Chris Yates
Follow /29 Jun 2015 at 7:10pm / SQL Server

Temporary Post Used For Theme Detection (7b252229-9e65-4bdb-a405-3b635012bd3b – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (975261a1-4b86-4b9f-ac10-01f0f0485a51 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
80 0 /
Ricardo Leka
Follow /29 Jun 2015 at 4:07pm / SQL Server

Event Notification para monitorar DeadLock

A algumas semanas tivemos a necessidade de substituir a forma que usávamos para monitorar Dead Lock por alguma coisa mais usual… Antes o Dead Lock era gravado no errorlog e depois encaminhado por email para o time,,, isso não é usual já que fica...
64 0 /
WaterOx
Follow /29 Jun 2015 at 2:30pm / SQL Server

Sneak Preview – Podcast 010 - WaterOx Consulting

Reading Time: 1 minutes Let’s Play A Game! So, just to tickle your fancy, here is... The post Sneak Preview – Podcast 010 appeared first on WaterOx Consulting .
81 0 /
Kenneth Fisher
Follow /29 Jun 2015 at 1:00pm / SQL Server

Zero to Speaker pt 2

A few months ago I wrote a post about the fact that I had actually submitted a session to PASS Summit . Well as I’m sure you are aware the selected sessions have been announced. They were officially announced Friday but I actually received my result...
81 0 /
Mark Broadbent
Follow /26 Jun 2015 at 8:30pm / SQL Server

Not Accepted for the PASS Summit 2015?

I guess it could be easy to become complacent about being selected to speak at conferences and you could certainly argue that I have been tremendously lucky with the selection process since I first broke into the speaking circuit in 2010. In 2011 I delivered...
141 0 /
WaterOx
Follow /26 Jun 2015 at 2:30pm / SQL Server

009 – Sam Vanga - WaterOx Consulting

Reading Time: 2 minutes A Friend (or Redgate) You Want To Have! In WOxPod!, episode #... The post 009 – Sam Vanga appeared first on WaterOx Consulting .
135 0 /
sqlkris
Follow /26 Jun 2015 at 2:00pm / SQL Server

How can I find Duplicate Values in SQL Server?

In this article find out how to find duplicate values in a table or view using SQL.  We’ll go step by step through the process.  We’ll start with a simple problem, slowly build up the SQL, until we achieve the end result. By the end you’ll understand...
118 0 /
Chris Webb
Follow /26 Jun 2015 at 9:30am / SQL Server

Automatically Generating Date Dimension Tables In Excel 2016 Power Pivot

As you probably know, whenever you are doing any kind of date or time-based calculations in DAX you should always have a separate Date table in your Power Pivot model. There are a number of ways of building these tables (see, for example, my Power Query...
132 0 /