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

Latest Blog Posts

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, 32 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, 109 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, 66 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, 65 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, 68 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, 86 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, 100 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, 87 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, 94 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, 103 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, 84 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, 116 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, 126 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, 82 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, 181 reads

Posted in Pearl Knows on 20 May 2015

SqlSaturday 377, Kiev, May 23 - only 3 days left

Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many famous speakers, including Kevin Boles, Benjamin Nevares, Dmitri Korotkevitch, Satya Jayanty, Mihail Mateev, Boris Hristov, Dmitry Piliugin and other.
Also you can attend 3 Pre-cons:

Read more

0 comments, 97 reads

Posted in SQL Code Guard on 20 May 2015

SQL Agent Job Wrapper Part 2 – Adding Error Generation to the Cmdlet

Last week I posted Creating a SQL Agent Job Wrapper with PowerShell and SMO. In that post I created a couple PowerShell scripts that run a SQL Agent job and wait for it to complete before exiting. That process could be called from the command line, or even from… Read more

0 comments, 69 reads

Posted in on 20 May 2015

Adding new users & groups in windows

I do a lot of testing with security in SQL Server. And of course to do a thorough job of it I need not just SQL Server logins but Windows logins. And that means I need to be able to create and delete windows users and groups. I could do… Read more

0 comments, 68 reads

Posted in SQLStudies on 20 May 2015

Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (af8cc091-a628-437f-8918-348486ad1d80 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

The post Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7) appeared first on Tim Mitchell.

Read more

0 comments, 107 reads

Posted in Tim Mitchell on 20 May 2015

Older posts