Latest Blog Posts
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The primary reason for this is to get the Actual Plan in order to see the differences between the Actual and Estimated Row Counts as a means of understanding how the… Read more
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF versions at the bottom.)
Filed under: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication Tagged: Humor
If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but SSIS does not natively support this operation. There is a built-in FTP task in SSIS, but it is very… Read more
Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here are two options to consider.
Single instance that host ALL the databases
Multiple instances with each having subset of the databases.
We`ve created a table with comparison of these two… Read more
I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using SP3’s that this may actually be helpful to some.
After playing around in a VM for a while now I decided to upgrade my SP3 to Windows 10 which comes… Read more
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit 2015, and now when I hear back from him, I am really very excited that I will be attending.
You must be wondering what is so exciting about this Summit… Read more
0 comments, 41 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 2 August 2015
It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not). If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in… Read more
Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by a DBA!
I don’t want to enter the DBA/Developer wars, but some sins committed by Developers really deserve a ticket to the SQL Server hell. In particular, some of those… Read more
This is a first article in a series of articles about real life database and IT infrastructure migration project which has been executed for a large US company which services are heavily dependent on fast and reliable database infrastructure. In this article we`ll give a brief description of the project,… Read more
The North Texas SQL Server User Group Board of Directors has decided to do something a little bit different for selecting Precons for our next SQLSaturday. The SQLSaturday event will be held on October 3rd with the precons on October 2nd. We have decided that since it is the community… Read more
As per the previous article, i have tried to create the understanding for Distributed Cache service : Understanding, Planning and Configuring Distributed Cache Service
In this current article will try to see with the planning and configuration of the DCS.
Planning & Capacity analysis of Distributed Cache Service:
Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking and looking at their phone. Texting, emailing, social media, and the like is all the buzz. I fall victim to this… Read more
Originally appearing at ForITPros.com.
In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government had leapfrogged America technologically. The dot that traversed the nighttime sky marked a change in international politics and fueled the… Read more
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.
You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more
In One Of the Group the question was asked that How to list all the Servers in which SQL is installed?
It is genuine query. There are many scenario when you need to Find out how much SQL servers are there in the domain ? many a times… Read more