Archives: April 2013
We came across a scenario where database bak files being created from long time which are no more in use and hence cleanup those files since we’ve backup tool is in place. We’ve many *.BAK (database backup files) created across ‘N’ number of servers. We have decided to cleanup all… Read more
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the sql server installation package and choose to install only this single feature. For developers, SQL Developer edition is a great choice.
When I started my blog two years ago, I never would have thought how much it would help my career. I can’t stress enough the importance of blogging to enhance your career. And it’s a lot easier to do than you think. I hope this blog post will encourage you… Read more
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at least 12 years without a single problem. They run DBCC CheckDB regularly to ensure the database is in healthy state until few days ago their DBA ran
DBCC CHECKTABLE with… Read more
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what I’ve learned and what I want to do next. I haven’t take 2 weeks in a row off in almost 3 years, so a nice vacation, some thinking, some yard… Read more
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and effort.
Here’s a few tricks that can improve your productivity when working with it:
1. Snippets and Keyboard Shortcuts
The amount of time these two features saved me is… Read more
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing SQL Server Performance” with Patrick O’Keeffe who is Director of Software Development at Dell Software Group. I must say, it was a really interesting experience.
Writing a blog… Read more
Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at a Business Analytics conference. This session is hosted by the PASS Virtual Chapter for Business Analytics which was started by Mellissa.
May 2nd PASS BA VC Meeting
4 comments, 1,207 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 April 2013
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. One of the things I’ve noticed is that while I frequently see system views referenced I only very rarely see the INFORMATION_SCHEMA views mentioned. This seems rather strange to me… Read more
Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following all the steps precisely on this page:
Configure PerformancePoint Services: http://technet.microsoft.com/en-us/library/ee748644.aspx
We opened the dashboard designer. Next we started to create a Data Source to an SSAS Tabular model, but… Read more
Last month, I began a series of articles describing database application benchmarking. In the first article, I told you about different ways that you can construct your own database application benchmark. However, you don’t have to reinvent the wheel. The Transaction Processing Council (www.tpc.org) has already created… Read more
Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on schedule, but many of them show no history. You look around, and there doesn’t seem to be a nightly job history purge (you’re looking for something with “sp_purge_jobhistory“).… Read more
We have a scheduled maintenance window to recycle SQL SERVER Instance once in 30 days hence created a PowerShell job where function being placed along with parameters(servername and instancename) and executed it across all SQLinstance. (Named or Default instance) Default instance-> MSSQLSERVER and Named Instance ->MSSQL`$KAT ( To… Read more
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be… Read more
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which is a pretty cool piece of kit, it’s entitled “How to find a missing FitBit”. For those of you who don’t know what they… Read more
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away from an established career focus to do something else for a while. I’ve been a SQL guy for a long time, I started using SQL Server in 1998 and… Read more
Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be the home for a SQL Server database engine supporting a SharePoint 2013 farm. Since it is a back-end database, the server was not connected to the Internet. Instead, it was… Read more
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically, can you build a Shared Dataset that combines multiple tables from the same database? To be honest, I wasn’t sure initially because I never attempted to. However, after a little… Read more
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx
Returns a row for all common language runtime (CLR) tasks that are currently running. A Transact-SQL batch that contains a reference to a CLR routine creates a separate task for execution of all the managed code in that batch.… Read more