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

Latest Blog Posts

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for SQL admins installing a new SQL Server instance going back a few years, so it's about time to put all my notes about the solution into a single…

Read more

0 comments, 952 reads

Posted in SQL Tact on 21 January 2016

Book review – Extending SSIS with .NET Scripting

Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost van Rossum (blog | twitter). My .NET scripting knowledge could use an update, so I decided to read the whole book and provide you with a full… Read more

2 comments, 1,638 reads

Posted in Koen Verbeeck on 21 January 2016

Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks

There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8 Steps to Better Transaction Log Throughput" from Kimberly Tripp (blog/@KimberlyLTripp) of SQLskills as well as the several other posts she links to from…

Read more

0 comments, 122 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 January 2016

Return of the .NET - NYC

Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about the return of the NYC .NET Developers group.  Worthy news for those like me in my neck of the woods, I am pleased to announce that after a… Read more

0 comments, 248 reads

Posted in Pearl Knows on 21 January 2016

What is RapidMiner

RapidMiner Overview

If you are searching for a data mining solution be sure to look into RapidMiner.  RapidMiner is an open source predictive analytic software that provides great out of the box support to get started with data mining in your organization.  They offer a free desktop software version to… Read more

0 comments, 137 reads

Posted in Business Intelligence and Enterprise Architecture on 21 January 2016

Transaction Logging & Recovery (part 3)

Transaction Logging & Recovery (part 3)

… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction Log. Please consider supporting his excellent material by using Pluralsight and subscribing to his blog. He’s contributed a vast amount… Read more

0 comments, 364 reads

Posted in SQL Barbarian on 20 January 2016

Power BI and Google Analytics

One of the more underused features of Power BI is the Google Analytics data source.  Working closely with marketers and agencies I continue to see them struggle with getting and reporting on their data from Google Analytics and it should not be that difficult.   With Power BI or even with… Read more

0 comments, 348 reads

Posted in Another SQL Geek on 20 January 2016

Advent of Code–Day 2

I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it was tricky in SQL I decided this one was worth a post, since I had to futz around a few times to solve it, and I managed a slightly different… Read more

0 comments, 160 reads

Posted in The Voice of the DBA on 20 January 2016

HA/DR for Azure SQL Database

Azure SQL Database is a relational database-as-a-service in the cloud.  It uses a special version of Microsoft SQL Server as its backend that is nearly identical to SQL Server (see Azure SQL Database Transact-SQL differences).  While there are many benefits to using SQL Database over SQL Server, in this… Read more

0 comments, 254 reads

Posted in James Serra's Blog on 20 January 2016

Start SQL Server without tempdb

tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.

While at the 2015 Summit I walked into the last few minutes of Russ Thomas’s (b/t) session on Stress Inoculation: Maintaining Performance Under Pressure. As a side… Read more

1 comments, 128 reads

Posted in SQLStudies on 20 January 2016

Using SQL Server Change Tracking for Incremental Loads

Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started using this technology for change detection. In this post, I’ll continue what I started by demonstrating how change tracking fits into a larger design pattern for end-to-end incremental load… Read more

3 comments, 989 reads

Posted in Tim Mitchell on 20 January 2016

SQL Server Community Activities under Surat User Group

I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on 23rd Jan 2016 at 5 PM.  

Well, this will be the first appearance as a speaker after 2012, since this is on-demand session there will be limited number of…

Read more

T-SQL Tuesday #74: Be the Change Round-up

Thanks to everybody that participated in this month’s T-SQL Tuesday. A big thanks to everyone who wrote a participating blog post, and a really huge thanks to everyone who read the posts shared by this month’s participants. If you follow one of the links on this round-up page, I will…

Read more

Change Availability Group Endpoint Port

Let’s say you have a port conflict and need to change the port on your Availability Group endpoint.  How can we accomplish this?

The first step is to change the port on the endpoint itself.  Note that as soon as you do this the replica on which you are running… Read more

0 comments, 166 reads

Posted in Ryan Adams on 19 January 2016

New SQL Blogging Challenge

I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory level blog per month for the community.

A simple statement with a profound substance to it. How many times do you and I take for granted… Read more

1 comments, 129 reads

Posted in The SQL Professor on 19 January 2016

Stop using Task Manager to check SQL’s memory usage!

There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why SQL’s using too much memory, or why it’s using too little.

Too much memory isn’t usually a real problem, it’s often due to max server memory being left at its… Read more

4 comments, 131 reads

Posted in SQL In The Wild on 19 January 2016

Shrinking Database Data Files

Normal DBAs will sum up shrinking a database data file in one word: NO!

I’ll talk to you about this subject because I’m not normal.  Still, my goal is that you’ll go from “why can’t I shrink my files” to “I don’t want to shrink my files.”

Truth be told,… Read more

1 comments, 636 reads

Posted in Simple SQL Server on 19 January 2016

How to Solve the Tail Insert Problem

In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s problematic.

In a nutshell, since traditionally we want our clustered index key to be narrow, static and ever-increasing, Identity is in many cases a very good choice. But since… Read more

1 comments, 128 reads

Posted in Matan Yungman on 19 January 2016

SQL Saturday Melbourne (#464) – 20 Feb 2016

For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.

SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are covered by donations and sponsorships.  Some of the excellent sponsors this year are PASS, RockSolid… Read more

0 comments, 122 reads

Posted in Mr. Fox SQL on 18 January 2016

Disabling SQL Server Network Protocols

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I ran across a question on network protocols recently, which is something I rarely deal with. Often the default setup for SQL Server is fine, but there are… Read more

0 comments, 354 reads

Posted in The Voice of the DBA on 18 January 2016

Newer posts

Older posts