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

Latest Blog Posts

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, 61 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, 26 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, 40 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, 36 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, 67 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, 111 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, 68 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, 67 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, 69 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

0 comments, 80 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

1 comments, 88 reads

Posted in DwainCSQL on 21 May 2015

MergeUi is on

I have put the code for MergeUi on github now:

That is all.


Read more

0 comments, 101 reads

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

MergUi 0.1.9

What is MergeUi?

A Visual Studio Addin to create and edit MERGE statements in SSDT projects.

What have you done?

I have released a new version of MergeUi, thanks to Luca Zavarella for prodding me into getting this release out and for pointing out some bugs!

This has a number…

Read more

0 comments, 89 reads

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

Putting the ORM debate to bed

Hopefully this should put the ORM debate to bed, either use an ORM or don't but please don't access tables directly...

There are obviously reasons behind all of this but if you follow this golden rule you will have a happy DBA and user base.

Read more

0 comments, 98 reads

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

Coming soon: Minion Backup, featuring table based scheduling!

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June 1! Minion Backup by MidnightDBA is a stand-alone database backup module.  Once installed, Minion Backup automatically backs up all online databases on the SQL Server instance, and will incorporate…

Read more

1 comments, 106 reads

Posted in SQL Awesomesauce on 20 May 2015

SQL Server Virtualization Stairway Level 3 at SQLServerCentral

The third Level in my Stairway to Virtualization series is now live at SQL Server Central! In this Level, we will review building the ideal VMware-based virtual machine for your SQL Server workloads. Review and incorporate your own corporate standards and policies into these recommendations, and build the VM… Read more

0 comments, 85 reads

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

SQL Server 2016 public preview arriving this summer

SQL Server 2016 was recently announced.  Top new features include:

  • Always Encrypted protects data at rest and in motion.  With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the application in the customers trusted environment.  Encryption and decryption of…

Read more

0 comments, 117 reads

Posted in James Serra's Blog on 20 May 2015

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s a simple test built against a user defined function. It works well and when the test is run, it passes.

Here was my code:

ALTER function [dbo]

Read more

0 comments, 127 reads

Posted in The Voice of the DBA on 20 May 2015

SQL F.A.D. – Daily Identity Reset - WaterOx Consulting

Reading Time: 3 minutes

Sometimes you have to do some things considered pretty strange in your...

The post SQL F.A.D. – Daily Identity Reset appeared first on WaterOx Consulting.

Read more

1 comments, 83 reads

Posted in WaterOx SQL on 20 May 2015

HealthySQL - A Comprehensive Guide to Healthy SQL Server Performance

On an otherwise uneventful, other than the normal busy, plate full, heading towards the US holiday weekend, middle-of-the-week, over the hump day, a personal achievement has been officiated this day, Wednesday the 20th of May, 2015.  Definitely not on the scale of the day of infamy, maybe… Read more

0 comments, 183 reads

Posted in Pearl Knows on 20 May 2015

Older posts