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

Latest Blog Posts

Outlier Detection with SQL Server, part 3.4: Dixon’s Q-Test

By Steve Bolton

…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we delved into a subset of standard detection methods taken from the realm of statistical hypothesis testing. These are generally more difficult to apply to tables of thousands of… Read more

0 comments, 37 reads

Posted in Multidimensional Mayhem on 30 January 2015

When Do You Ask for Help?

Being on the edge of a cliff is a common feeling when running a small business

Stepping Back

I am taking this moment to step back to try to process a few things myself in this post to hopefully gain some clarity.

These are my ramblings on the state of… Read more

0 comments, 35 reads

Posted in WaterOx SQL on 30 January 2015

Part 3 Adding Tab Controls – Create your own SQL tools with PowerShell and windows forms


James recently published part 3 of his PowerShell and Windows Forms series for creating your own SQL Tools. In this post, he guides you through the process of adding tab controls. Enjoy!

Originally posted on JamesDataTechQ:

Using Tab Controls can help you organize and define your work…

Read more

0 comments, 43 reads

Posted in DataOnWheels on 30 January 2015

Virtualization for SQL Server DBAs – SQL Saturday Phoenix Precon

I am pleased to announce that I have an upcoming preconference training session on Friday, February 27th, the Friday before SQL Saturday Phoenix.

Virtualization for SQL Server DBAs

Session Information: Microsoft MVP, VMware vExpert, and SQL Server performance expert David Klee leads this full-day introduction to enabling and… Read more

0 comments, 38 reads

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

I May Not Shake Your Hands

I’m traveling next week to the SQL Konferenz in Germany, and then on to Red Gate in the UK.

However, I may pull a Wil Wheaton at the event and the office and not shake hands. I haven’t had issues with this in the past, with lots of handshakes, hugs,… Read more

0 comments, 91 reads

Posted in The Voice of the DBA on 30 January 2015

Friday Followup For January 30, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed…

Read more

0 comments, 51 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 January 2015

More Azure SQL Database Enhancements – Meet RLS (cloud first debut)


Well, it was only a few  days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in that post,I was referring to new features that were made available in the new V12 preview portal, specifically for moving “On Prem” database to Azure SQL… Read more

1 comments, 87 reads

Posted in measure twice, cut once. on 30 January 2015

Trapping Online Index Operations

Recently I wrote an article about Capturing Online Index Operations.  In that article, I discussed a problem that I had encountered.  Well, there were multiple problems.  One was an issue with a vendor app that had some hidden module that was performing online index defrags that was causing corruption… Read more

0 comments, 58 reads

Posted in SQL RNNR on 29 January 2015

Minion Reindex 1.1 Release (and re-release)

We released Minion Reindex version 1.1 last week. The changes are fairly small: Made sure Minion Reindex handles all nonstandard naming (e.g., object names with spaces or special characters). Added support for Availability Group replicas. (Basic AG support has been added by only permitting Minion Reindex to run on an…

Read more

0 comments, 104 reads

Posted in SQL Awesomesauce on 29 January 2015

Changing File Associations in Windows 8

A quick post, and a good reminder of something that can be a pain. I had to do a quick search for the solution, and wanted to write about it in the hopes it will help me remember the issue.

Opening the wrong program

I was working with some XML… Read more

0 comments, 99 reads

Posted in The Voice of the DBA on 29 January 2015

Installing multiple default instances on a single server

As you probably know, SQL Server allows only one default instance per server. The reason is not actually something special to SQL Server, but it has to do with the way TCP/IP endpoints work.

In fact, a SQL Server default instance is nothing special compared to a named instance: it… Read more

2 comments, 81 reads

Posted in SpaghettiDBA on 29 January 2015

Exam Prep 70-463: Data Flow Transformations  

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 79 reads

Posted in Cleveland DBA on 29 January 2015

Difference of Index Partition and Creating Service application in partitioned Mode

Hi All, 

I am sharing the response and question which I received on my mail based on past post : “Configure search topology in scale out mode in SharePoint 2013”  .

What I received is “If we are using index partition and replica, then why we are not creating Search…

Read more

0 comments, 110 reads

Posted in AshishSharePointBlog on 29 January 2015

T-SQL Tuesday #62 - Wrap Up!

This month’s T-SQL Tuesday #62, the first of 2015, hosted by yours truly, (invitation to Healthy SQL here), asked that you all blog about your T-SQL Resolution, and describe what it is that you will do this year to make sure your SQL Servers are healthy provide… Read more

0 comments, 105 reads

Posted in Pearl Knows on 29 January 2015

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this year.  The workshop is available from an hour-long quick demo to a full-day, hands-on workshop with a hosted lab environment in the cloud.  The series teaches how to create a…

Read more

4 comments, 91 reads

Posted in SQL Server BI Blog on 29 January 2015

Out of Space

I’ve used placeholders to ensure I don’t run out of space on my machines. That’s worked well, and usually I can delete a placeholder when I have an emergency, and then clean up the drive.

However I got a low warning today when trying to do an iOS upgrade.

I’d… Read more

1 comments, 118 reads

Posted in The Voice of the DBA on 28 January 2015

Oh Look, A Horseless Carriage

Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve got a special talent, a unique knowledge set, and it’s fulfilling a defined need. So we’re all set, right?

Well, other than that Stanley Steamer over there. And maybe that… Read more

2 comments, 82 reads

Posted in The Scary DBA on 28 January 2015

A quick email interview of Pass President Thomas LaRock

Back in December I had the thought that it would be fun to do an email interview with someone. As I thought about it Thomas LaRock (b/t) sounded like a good choice since he has been working in the community for quite a while and is… Read more

0 comments, 76 reads

Posted in SQLStudies on 28 January 2015

SQL Saturday 360 in Israel

I had the pleasure to speak at SQL Saturday 360 in Israel. It was such a great event! We had two tracks, one for SQL Server and one for BI. There were more than 160 people who enjoyed free training, great food, networking and fun. There was even a beer… Read more

0 comments, 63 reads

Posted in Guy Glantser on 28 January 2015

New Power BI Preview and Pricing

Some exciting announcements were made today about the new Power BI cloud-based business analytics service.  Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month.  Data transformation queries, data models and dashboard visualizations are all created using add-in…

Read more

0 comments, 95 reads

Posted in SQL Server BI Blog on 28 January 2015

Older posts