Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

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 facing severe issues with their environment, they can… Read more

0 comments, 85 reads

Posted in MSSQLFUN on 25 May 2015

Cumulative Update – 6 for SQL Server 2012 Service Pack 2 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 84 reads

Posted in MSSQLFUN on 25 May 2015

SQL Server 2014 Service Pack 1 (SP1) Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2014 Service Pack 1 (SP1), Same is now available for download at the Microsoft Support site. SQL Server 2014 Service Pack 1 (SP1) contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

I suggest to… Read more

0 comments, 85 reads

Posted in MSSQLFUN on 25 May 2015

CDO Summit Toronto June 4th

I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th.  My session is on how to leverage predictive analytics to reduce customer churn.  I will be going over how I leveraged a decision tree model to create a customer risk score for active customers.… Read more

Azure Columnstore, part 3 – Modern Segment Elimination and Set Statistics IO

Welcome to the 3rd blog post in the Azure Columnstore series, this one is dedicated to one very important improvement that Microsoft has added to Azure SQL Database v12 – the number of segments read and skipped whenever reading Columnstore…

Read more

0 comments, 116 reads

Posted in Niko's blog on 24 May 2015

Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)

Continuation from the previous 52 parts, the whole series can be found at http://www.nikoport.com/columnstore/ This is a very small blog post which will focus on 1 essential change that happened in Service Pack 1 for SQL Server 2014. The only…

Read more

0 comments, 145 reads

Posted in Niko's blog on 22 May 2015

How I Got Started in Software Development-A Tribute to Ed

Steve:

Happy Memorial Weekend everyone. This is a time to remember those who have gone before and in some cases have left us. I started a tribute series that celebrates those who have had an impact on me as a person and on my career. It started with my…

Read more

0 comments, 100 reads

Posted in DataOnWheels on 22 May 2015

Unit Testing in Philadelphia

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your T-SQL code. We’re the day before SQL Saturday #390 in… Read more

0 comments, 164 reads

Posted in The Voice of the DBA on 22 May 2015

VM Memory Counters Lie for SQL Server VMs

A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the other speakers about SQL Server VM-level memory counters and their (lack of) validity on the actual memory usage properties of the SQL Server engine. A while back, I… Read more

0 comments, 110 reads

Posted in Technobabble by Klee from @kleegeek on 22 May 2015

004 – Cracked Foundation - WaterOx Consulting

Reading Time: 4 minutes

Do You Have a Cracked Foundation? in WOxPod!, episode # 004 –...

The post 004 – Cracked Foundation appeared first on WaterOx Consulting.

Read more

1 comments, 140 reads

Posted in WaterOx SQL on 22 May 2015

Speaking at SQLSaturday Rheinland, Germany 2015

It is always a very special moment whenever you receive a notification of being selected to present at any event. This feeling becomes much bigger whenever it handles about an international event that you love. I have been presenter of…

Read more

0 comments, 121 reads

Posted in Niko's blog on 22 May 2015

Reblog - Memorial Day in US - Freedom is Never Free

Originally published May 2014:

Well, as all folks in the United States know, this weekend we celebrate Memorial Day, Monday May 25, 2015.  While many of us who will enjoy this extended long weekend with our family and friends, barbecues, picnics, amusement parks, shopping and the beach, we should… Read more

0 comments, 161 reads

Posted in Pearl Knows on 22 May 2015

DB_Owner Querying for Database Options

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, assign permissions, back up the database, etc). However someone… Read more

0 comments, 311 reads

Posted in The Voice of the DBA on 21 May 2015

Power BI with Azure SQL Database

**Information is current as of 5/21/2015**

Recently Azure SQL Database was added as a new connection to the Power BI Preview. Read the notes about how it can be used here. The things I found especially worth noting were:

  • Every action sends a query back to the database. So…

Read more

0 comments, 108 reads

Posted in Devin Knight on 21 May 2015

Creating an Azure SQL Database

By David Postlethwaite

Once you have logged in to the Azure Management Portal you can start to  create an Azure SQL Database.
Azure SQL Database is an example of Platform as a Service (PaaS), we don’t have to build a Windows server or install the SQL software or configure the…

Read more

0 comments, 105 reads

Posted in The SQL DBA in the UK on 21 May 2015

Advanced SSIS Training Classes This Fall

Now that the details have been finalized, I can announce that two new SSIS classes are coming up this fall. My Linchpin People cohort Andy Leonard and I will be delivering our Advanced SSIS training class in two new locations later this year: in the Atlanta area in September, and… Read more

0 comments, 116 reads

Posted in Tim Mitchell on 21 May 2015

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded one of our servers from SQL 2012 to SQL 2014 and a job started failing. (Although I haven’t explicitly tested this behaviour on earlier versions – the job dates back… Read more

1 comments, 122 reads

Posted in Ctrl-alt-geek on 21 May 2015

The Best Tool for Comparing Whether Two T-SQL Queries Produce Identical Results

There is one software tool that should be in every software developer’s tool chest.  That is knowledge of the platform on which you are developing.  With all the hype that surrounds every new software tool that comes out, it is important to recognize the tools you already have at hand,… Read more

10 comments, 3,391 reads

Posted in DwainCSQL on 21 May 2015

MergeUi is on github.com

I have put the code for MergeUi on github now:

https://github.com/GoEddie/MergeUi

That is all.

Tags: 

Read more

0 comments, 139 reads

Posted in Ed Elliott's Sql Developer Blog on 21 May 2015

Newer posts

Older posts