Latest Blog Posts
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…
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
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
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
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
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
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
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
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
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
0 comments, 91 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 20 January 2016
1 comments, 182 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 20 January 2016
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
A simple statement with a profound substance to it. How many times do you and I take for granted… Read more
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
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
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
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
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