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

Latest Blog Posts

Memory Fundamentals for SQL Server - AWE ( Address Windowing Extensions), /PAE Switch (Physical Address Extension)

In the previous blog we saw the difference between Virtual Address Space between 32-bit and 64-bit systems. We also saw how virtual memory works and how /3GB switch can be used to increase the user access mode limit.

In this module we shall see what is AWE and /PAE…

Read more

2 comments, 742 reads

Posted in Kruti's SQL Blog on 1 February 2016

My Best Blog Posts from 2015


About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely – simply reposting a slight variant of a given blog post could hurt your overall… Read more

0 comments, 113 reads

Posted in Kevin E. Kline on 1 February 2016

Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported

Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it …

Continue reading Read more

0 comments, 168 reads

Posted in Kapil Blogs on 1 February 2016

SQL Server 2016: configure TempDB during installation

Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended strategy is to create multiple data files, one per CPU core (logical processor), but not more than 8.  Those files should be equal in size and with the… Read more

6 comments, 1,050 reads

Posted in Gorandalf's SQL Blog on 31 January 2016

PowerShell Pester Testing for Parameter Validation

This error caught me out. I am putting this post here firstly to remind me if I do it again adn also to help others who may hit the same issue.

Today I am rewriting a function to create a Hyper-V VM so that I can properly script the creation… Read more

1 comments, 611 reads

Posted in SQL DBA With A Beard on 31 January 2016

PowerShell Pester – "The script failed due to call depth overflow."

This error caught me out. I am putting this post here firstly to remind me if I do it again and also to help others who may hit the same issue.

I also have been looking at Pester which is a framework for running unit tests within PowerShell

You will… Read more

3 comments, 534 reads

Posted in SQL DBA With A Beard on 31 January 2016

Meet the Team- Eitan Blumin

When I was about 7 years old and got my first computer during the early nineties,
I said “This is the future”.

Now that the future is here and computers are everywhere, I take a look at the world of Data and say “This is the future”.

I started out… Read more

0 comments, 113 reads

Posted in Eitan Blumin on 31 January 2016

Speaking at SQLSaturday Chicago

I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! 

My presentation is “Performance Monitoring AlwaysOn Availability… Read more

0 comments, 143 reads

Posted in Anthony Nocentino's Blog on 29 January 2016

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, 183 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, 158 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, 153 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, 150 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, 117 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,364 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, 187 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, 162 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, 195 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, 134 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, 145 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, 176 reads

Posted in James Serra's Blog on 27 January 2016

Newer posts

Older posts