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

Latest Blog Posts

MySQL TinyInt treated as Boolean

When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the issues are related with handling of certain data types such as “TinyInt”.

A particular issue I recently came upon was the fact that TinyInt(1) is treated by default… Read more

0 comments, 81 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 29 April 2015


Today’s blog will be the first in a multi-part series on replicating Excel functions in T-SQL, starting with HARMEAN, GEOMEAN and FREQUENCY.

We’ll focus our solutions on creating T-SQL in-line, Table Valued Functions (iTVFs), introduced in SQL Server 2005, that apply the solution technique to a specifically designed… Read more

1 comments, 94 reads

Posted in DwainCSQL on 29 April 2015

Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller

This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.

In Part I of this series, I showed you how to setup the networking and router for our simulated network. In this article,… Read more

1 comments, 89 reads

Posted in The Data Files on 29 April 2015

Using SSIS Lookup Transformation in ETL Packages

Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of two datasets: input columns from a data source and columns in a reference dataset – a table, view or a result of a query. Lookup can be used in… Read more

1 comments, 160 reads

Posted in Gorandalf's SQL Blog on 29 April 2015

Restoring a database that doesn't exist

When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more

0 comments, 81 reads

Posted in BIT Barbarian on 28 April 2015

A Tale of SQL Server Disk Space Trials and Tribulations


System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the following data files: two files in the PRIMARY filegroup, and one other file in another filegroup, plus one log file. It used to have two log files…

Current… Read more

1 comments, 143 reads

Posted in Todd Kleinhans on 28 April 2015

Using PowerShell to Export SQL Data to CSV. How well does it perform?

So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following post on Twitter #sqlhelp, and after I posted my response I thought that this would make a fun blog post. I have used PowerShell to export SQL Server tables to… Read more

0 comments, 162 reads

Posted in on 28 April 2015

Windows Temporary Profile

Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc you get the message that you have been logged in with a temporary profile.
Well that was what happened to me Friday evening. My heart sank. Have I lost all…

Read more

0 comments, 86 reads

Posted in The SQL DBA in the UK on 28 April 2015

Use PsPing When Working in Azure IaaS

Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best ways for me to learn about Azure was to build out my own environment using VMs, or Infrastructure as a Service (IaaS). All of that was easy; however, once the…

Read more

0 comments, 75 reads

Posted in Everyday SQL on 28 April 2015

Moving SQL Server data between filegroups – Part 2 – The implementation

In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our two part series on “Moving SQL Server data between filegroups – Database Structures”, you can find the first article… Read more

0 comments, 200 reads

Posted in Anthony Nocentino's Blog on 28 April 2015

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

Continuation from the previous 51 parts, the whole series can be found at Microsoft has launched Service Pack 1 for SQL Server over a week ago (15th of April was the release date I believe), and unfortunately the original…

Read more

0 comments, 109 reads

Posted in Niko's blog on 28 April 2015

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way.


The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 89 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 189 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery

In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored procedures differ from normal stored procedures in that the In-Memory OLTP… Read more

1 comments, 117 reads

Posted in The DBA Who Came In From The Cold on 27 April 2015

Dear Vendor: Keep My Information Secure

Dear vendor:

Dear Vendor: Keep My Information Secure

If you’re reading this, we have done business together, either directly or indirectly. You might be a retail website from which I purchase products or services. You could be a social media empire on which I share blog posts, life events, and… Read more

1 comments, 80 reads

Posted in Tim Mitchell on 27 April 2015


It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me… Read more

5 comments, 138 reads

Posted in The SQL Professor on 27 April 2015

The May Blogger Challenge–Continuing On

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging.

Building on April

To make the next step in starting to blog regularly,… Read more

0 comments, 132 reads

Posted in The Voice of the DBA on 27 April 2015

Monday Morning SQL Break – April 27, 2015

It’s been a while since I’ve posted a blog post.  After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years.  Of course, analysis paralysis and my lacking php skills… Read more

0 comments, 74 reads

Posted in StrateSQL on 27 April 2015

Upcoming SQL Saturday Precon Sessions

I have two exciting SQL Saturday preconference training sessions coming up in the month of May!

The first is my Virtualization for SQL Server Professionals training session at SQL Saturday Rochester NY on Friday, May 15th.

Session Abstract: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction… Read more

0 comments, 67 reads

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

Benefits for Some, All or Only a Few

As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can read more about it here and here (as well as here).

Let me start with an important note: I am voicing my opinion here as an individual, not an… Read more

18 comments, 81 reads

Posted in The Scary DBA on 27 April 2015

Newer posts

Older posts