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

Latest Blog Posts

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, 47 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, 42 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, 100 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, 49 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

0 comments, 82 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, 67 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, 83 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, 123 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, 77 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, 76 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, 79 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, 93 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, 94 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, 107 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, 95 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, 101 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, 111 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, 91 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, 123 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, 133 reads

Posted in The Voice of the DBA on 20 May 2015

Older posts