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

Latest Blog Posts

Upgrade from SQL 2014 Evaluation to Developer Edition

Couldn't find documentation showing that upgrade from SQL 2014 evaluation version was possible to developer edition. I just successfully converted an evaluation version to developer edition.

  1. Obtain the key for the developer edition (in my case I had to download the .ISO from MSDN downloads, and go through the installation…

Read more

0 comments, 14 reads

Posted in BIT Barbarian on 4 May 2015

TechEd is now Microsoft Ignite

In case you were wondering what happened to the TechEd conferences, Microsoft is now bringing together the best of previously individual events – the Management Summit, the Exchange, SharePoint, Lync, Project, and TechEd conferences – and then taking it to the next level, based on what customers and partners have… Read more

0 comments, 4 reads

Posted in James Serra's Blog on 4 May 2015

Monday Morning SQL Break – May 4, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you don’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 41 reads

Posted in StrateSQL on 4 May 2015

SQL Code Guard v2.8 released

Main change - SCG moved back to .Net framework 3.0 to restore support of SSMS 2008/2008R2
Few small fixes, additional logging, nothing critical.

Read more

0 comments, 70 reads

Posted in SQL Code Guard on 4 May 2015

Building a job to monitor other jobs

The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows tasks to run SQL Processes. Now why would you ever want to do this? Well if you are running SQL Server Express… Read more

0 comments, 49 reads

Posted in SQLStudies on 4 May 2015

I am not able to access my SQL server instance on another computer tip #98


On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server machine in the office through his machine. I think this is generalized problem and might be faced by many of us.

So to begin with  default port… Read more

1 comments, 40 reads

Posted in Rajat Jaiswal-337252 on 4 May 2015

ETL #72–Your data can mysteriously disappear after a WHERE clause was added (2)

Why a seemingly innocent WHERE clause can cause large amount of data missing

In the previous post, ETL #71–Your data can mysteriously disappear after a WHERE clause was added (1), I talked about how I discovered a WHERE clause was added to a main procedure that processes the raw… Read more

0 comments, 70 reads

Posted in Sherry Li's BI Corner on 3 May 2015

Overview of Azure Data Services

The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all in mind and understand what exactly is each one for and when to use waht. This article is a summary of the Data Service as of April 2015. I’ll… Read more

0 comments, 79 reads

Posted in Gorandalf's SQL Blog on 3 May 2015

Using SQL Code Guard TFS Checkin Policy with VS2013

To use TFS Checking policy the first thing that you must do - is to add policy to your TFS source control
The process itself is pretty simple

  1. Install SQL Code Guard at target computer. Please remember that you will need to have SCG installed on each computer on which…

Read more

0 comments, 61 reads

Posted in SQL Code Guard on 2 May 2015

Thanks for the Help with Deadlocks

It's time to start blogging again. And for my first post in a very long time, I mainly want to thank the SQL Server community for putting so much valuable information out there. Recently we had a rare deadlock appear, and it reminded me of a previous encounter I had… Read more

0 comments, 92 reads

Posted in Stephen Tirone - Adventures with Data on 2 May 2015

May 13th – Standardized SQL Installations – Script Review & Demo

This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

Read more

0 comments, 105 reads

Posted in SQLFeatures on 2 May 2015

Building Your Data Team’s Make Up and Culture

Join Adam Jorgensen and Pragmatic works to learn about Building Your Data Team’s Make Up and Culture on Tuesday, May 5.

Read more

0 comments, 111 reads

Posted in DataOnWheels on 1 May 2015

Speaker of the Month: May 2015

I finally got out to some community events last month and got to see a bunch of great speakers. Not that you don’t see great speakers at paid events, you do. It’s just that they’re usually professional speakers and I want to encourage others when I can.

The Speaker of… Read more

4 comments, 94 reads

Posted in The Scary DBA on 1 May 2015

Announcing Minion Enterprise: the new SQL Server Management Solution

A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database administrator must spend a large amount of…

Read more

4 comments, 469 reads

Posted in SQL Awesomesauce on 1 May 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more

0 comments, 265 reads

Posted in BIT Barbarian on 30 April 2015

Excel BI Tip #26: Using a Data Spreadsheet or Tab

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 126 reads

Posted in DataOnWheels on 30 April 2015

Elite VMware SQL Server Workshop Wrapup

This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months,… Read more

0 comments, 76 reads

Posted in Technobabble by Klee from @kleegeek on 30 April 2015

Spinach and Database Development- SQLSatExeter Keynote

Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote video by Phil Factor about Spinach and Database Development. With many thanks to those that made it possible and particularly to Phil… Read more

1 comments, 110 reads

Posted in SQL DBA With A Beard on 30 April 2015

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015

In my last post, I discussed some of the concepts around Sharding and how we could use Sharding and Azure Database Elastic Scale in a real world application to implement Horizontal Scaling. In…

Read more

0 comments, 162 reads

Posted in Pie in the Sky on 30 April 2015

Older posts