Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Call for Speakers for Orlando Code Camp 2016 Ends February 6, 2016

Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).

Read more

0 comments, 161 reads

Posted in SQLAndy on 29 January 2016

SSC Editorial: Turn Out the Lights

This ran a couple weeks ago (Turn Out The Lights) to see if I could spark a discussion about how/when/why we might think more about costs incurred by the way we provide solutions. Based on the follow-on discussion I didn’t quite achieve that. It reminds me that there… Read more

0 comments, 136 reads

Posted in SQLAndy on 29 January 2016

Easy way to test log shipping or availability groups setup

Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention after all the training on log shipping and availability groups that you can use a lab environment from TechNet to actually get going on familiarizing yourself with the technology more. Read more

2 comments, 145 reads

Posted in SQL Barbarian on 29 January 2016

PASS Board 2016: Update #1

Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I will continue to communicate all that I can about my role as EVP throughout the year. One of our commitments this year is providing greater insight into each of the… Read more

0 comments, 143 reads

Posted in The Scary DBA on 29 January 2016

First foray into presenting

It’s been a while since I’ve posted as the run up to Xmas last year and this January have been particularly busy. February doesn’t seem to be going to be any quieter but at least I’m being kept on my toes.

Anyway, waaaay back in December the SQL Server Ireland… Read more

0 comments, 112 reads

Posted in The DBA Who Came In From The Cold on 29 January 2016

SQL Server Principals – Back to Basics

Prelude in SQL Minor

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more

0 comments, 1,263 reads

Posted in SQL RNNR on 28 January 2016

Memory Fundamentals for SQL Server - Virtual Memory, /3GB Switch

Just a few days back I was asked a very basic question related to AWE and /3GB switch.I was surprised being a DBA I was unable to explain the concept and relate the terms by proper choice of words. That's when I realized how important it is to have this…

Read more

0 comments, 176 reads

Posted in Kruti's SQL Blog on 28 January 2016

Save the date: SQLSaturday Iowa City

Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?

A: True! SQLSaturday #19 was held in the fall of 2009 in Iowa City. We’re one of only a handful of chapters to host an event every year since then.

We’ll hold our eighth SQLSaturday… Read more

0 comments, 158 reads

Posted in The Data Files on 28 January 2016

Where in the world are Jen and Sean?

Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January report on what we’re up to, and where we’re going to be in the near future. What are we up to? Minion, of course! Also, Minion, and some Minion. In…

Read more

0 comments, 173 reads

Posted in SQL Awesomesauce on 28 January 2016

Reblog: Building the Script Component

SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components. 

The problem

From time to time I have to script out some logic using a Script Component in a SSIS package. Business as… Read more

0 comments, 130 reads

Posted in Koen Verbeeck on 28 January 2016

Encrypting AlwaysOn Availability Group Transport- Some thoughts!

Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.

The transport security involves encryption of packets exchanged between the servers involved, and for AlwaysOn AG the encryption is made possible on the Hadr_endpoint.

By default, its encrypted using AES Read more

0 comments, 141 reads

Posted in on 28 January 2016

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.

In this migration process you migrate both your schema and your data from the SQL Server database in your current environment into SQL Database, provided the existing database passes… Read more

0 comments, 165 reads

Posted in James Serra's Blog on 27 January 2016

The Importance of a Full Backup in SQL Server

This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely 100 level, introductory blog posts meant to help people that are just getting started as data professionals. I’ll try to cover several different topics over the year, but felt I… Read more

2 comments, 148 reads

Posted in The Scary DBA on 27 January 2016

The CONNECT permission

The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at the instance level, but prior to that it was just CONNECT. It does basically the same thing in both cases. The CONNECT permission allows you to connect to the associated… Read more

2 comments, 934 reads

Posted in SQLStudies on 27 January 2016

Goodness-of-Fit Testing with SQL Server Part 4.2: The Hosmer–Lemeshow Test with Logistic Regression

By Steve Bolton

…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using SQL Server to perform goodness-of-fit testing on regression lines, rather than on probability distributions. These are actually quite simple concepts; any college freshman ought to be able to… Read more

0 comments, 661 reads

Posted in Multidimensional Mayhem on 26 January 2016

Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016

Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ If you’re still on SQL Server 2005, there are some important things to be aware of.  First and foremost is that you are missing out on innumerable capabilities in more…

Read more

0 comments, 185 reads

Posted in SQL Server BI Blog on 26 January 2016

Speaking at SQLSaturday Chicago

I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I will be talking about the system_health Extended Events session and the default trace. Here’s the details:

Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)

As DBAs,… Read more

0 comments, 131 reads

Posted in The Data Files on 26 January 2016

Microsoft & R Programming Session Materials & Resources Available

Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power BI User Group. We took an introductory look at how Microsoft’s acquisition of Revolution Analytics is making serious waves across the Microsoft data platform. We also walked through leveraging… Read more

2 comments, 258 reads

Posted in SQL with Dustin Ryan on 26 January 2016

Does an index scan always read the entire index?


That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a scan.

A seek is an operation which navigates down the index’s b-tree looking for a row or for the start/end of a range of rows. A seek requires a… Read more

4 comments, 112 reads

Posted in SQL In The Wild on 26 January 2016

Tim Ford’s Entry-Level Content Challenge

All bloggers started as beginners.  We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge.  The problem is that most of us moved on to talking about advanced topics and left people to fend for themselves on the difficult entry-level learning… Read more

0 comments, 145 reads

Posted in Simple SQL Server on 26 January 2016

Newer posts

Older posts