SQL Server

SQL Server Community

SQL Server Blogs

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)
44 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...
44 0 /
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 .
54 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...
59 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...
125 0 /
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 .
116 0 /
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...
105 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...
118 0 /
Dinesh Asanka
Follow /26 Jun 2015 at 6:38am / SQL Server

Microsoft Offers Azure SQL Data Warehouse for Limited Preview

Microsoft is cracking the door to its cloud data warehouse. The Azure SQL Data Warehouse is now ready to accept data from customers in limited use cases. Azure SQL Data Warehouse, Microsoft's cloud-based data repository offering, is available as a...
124 0 /
Mark Broadbent
Follow /25 Jun 2015 at 6:51pm / SQL Server

Announcing SharePoint Saturday Cambridge – We got two tribes

In 2013, SQLSaturday Cambridge became the first ever SQLSaturday in the World to host a dedicated SharePoint track and the event was a great success. It struck me at the time how well we managed to get a SharePoint audience at an event that was largely...
107 0 /
Ricardo Leka
Follow /25 Jun 2015 at 3:59pm / SQL Server

Coisas que só o Powershell ISE faz por você

Tenho alguns clusters que estão em Multi-site, usando um Quorum em File Share para melhorar a disponibilidade. Como o “Cluster Core” conta como voto na contagem do cluster, tenho preferencia na localização do recurso, já que todos os nós...
101 0 /
Ayman El-Ghazali
Follow /24 Jun 2015 at 7:18pm / SQL Server

Working at Microsoft – A Year in Reflection

Last year after starting my new job with Microsoft as a Senior Consultant I wrote an article about my interviewing experience with many companies during my tenure at my last employer (Click here for article).  I realized it is now time to talk about my...
150 0 /
Dinesh Asanka
Follow /24 Jun 2015 at 7:03pm / SQL Server

Ex-Microsoft chief rolls elastic-SQL challenge to Amazon Redshift

SQL Server, with Windows and Office, helped make Microsoft. The database sits in a $13bn business unit and while Microsoft’s server products grew 11 per cent – $1.7bn last year – that was driven primarily by sales of SQL Server. The man who paved the...
134 0 /
Ed Elliott
Follow /24 Jun 2015 at 5:55pm / SQL Server

Why does sqlpackage.exe not compare after the pre deployment script has run?

It isn't a Pre compare script When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your database up to date with your dacpac. The important thing to note is that the...
126 0 /
Follow /24 Jun 2015 at 5:00pm / SQL Server

Database Owner Verification

There’s often low hanging fruit once you start looking into servers, or you just need to verify settings are correct.  Recently I had to verify that all databases had the correct owner for auditing purposes. There are many scripts out there to do...
119 0 /