SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2013

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.

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

0 comments, 1,073 reads

Posted in PowerSQL By Prashanth Jayaram on 30 April 2013

Installing SSMS 2012 all by it’s lonesome

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. 

Read more

0 comments, 26,567 reads

Posted in Sheldon Hull on 30 April 2013

Enhance your career by blogging!

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

20 comments, 2,787 reads

Posted in James Serra's Blog on 30 April 2013

SQL Server +0 and -0

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

2 comments, 1,520 reads

Posted in John Huang’s Blog on 30 April 2013

Looking Forward

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

0 comments, 1,381 reads

Posted in SQLAndy on 30 April 2013

Five Ways to Improve Your Productivity with SSMS

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

10 comments, 7,618 reads

Posted in Matan Yungman on 30 April 2013

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

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

0 comments, 1,396 reads

Posted in Richard Douglas on 30 April 2013

SQLDiva reviews the First PASS Business Analytics Conference

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 02

May 2nd PASS BA VC Meeting

Read more

0 comments, 1,286 reads

Posted in The Smiling DBA on 29 April 2013

How to collect cluster Information using TSQL

Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment.  I have spent sometime and created a…

Read more

INFORMATION_SCHEMA the un-sung system views

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

10 comments, 2,302 reads

Posted in SQLStudies on 29 April 2013

Configuring PerformancePoint in SharePoint 2013

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

0 comments, 1,817 reads

Posted in SQLDownSouth on 29 April 2013

Use TPC Database Benchmarks to Save Money

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

0 comments, 1,227 reads

Posted in Kevin E. Kline on 29 April 2013

Quick Tip: Where’s my SQL Server Job History?

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

1 comments, 1,159 reads

Posted in SQL Awesomesauce on 29 April 2013

PowerSQL -Recycle SQL Instance (Remote or Local)

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

0 comments, 1,350 reads

Posted in PowerSQL By Prashanth Jayaram on 29 April 2013

Last Weeks Top “Reading” Links #30

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

0 comments, 1,306 reads

Posted in StrateSQL on 29 April 2013

How to provide a better customer service

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

4 comments, 1,687 reads

Posted in Richard Douglas on 29 April 2013

Looking Back-Part 2

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

0 comments, 1,235 reads

Posted in SQLAndy on 29 April 2013

Error while enabling Windows Feature: Netfx3

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

2 comments, 7,081 reads

Posted in Koen Verbeeck on 29 April 2013

Creating a Shared Dataset with Report Builder

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

0 comments, 2,452 reads

Posted in SQLDownSouth on 29 April 2013

DMV-9 : Digging out details of CLR Tasks……..sys.dm_clr_tasks

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

0 comments, 1,744 reads

Posted in MSSQLFUN on 29 April 2013

Older posts