SQLServerCentral.com Content tagged Blogs

Roll Logs – Backup Recovery

Mon, 20 May 2013 06:00:00 UT

Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Indexes – Understanding basic types and their components

Sat, 18 May 2013 09:05:14 UT

The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...

Software Design and Schizophrenic Windows 8 Part 2

Sat, 18 May 2013 05:23:00 UT

I know it’s not schizophrenic, but that sounds better. It’s really a split personality. I wrote recently about Windows 8 and...

Windows, RIP (1992 – 2013)

Sat, 18 May 2013 02:54:41 UT

Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...

Certifiable?

Fri, 17 May 2013 19:08:40 UT

I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...

SQLSaturday #220 Atlanta

Fri, 17 May 2013 11:14:00 UT

From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...

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

Fri, 17 May 2013 06:00:00 UT

We came across a scenario where database bak files being created from long time which are no more in use...

Indexes – Unused and Duplicates

Fri, 17 May 2013 05:16:01 UT

Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?

Fri, 17 May 2013 01:19:30 UT

This is my first SQLSaturday and I’m super excited to attend this event. SQLSaturday’s are always a great opportunity to learn something exciting,...

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Virtualization Networking Tips for SQL Server 2012 AlwaysOn

Fri, 17 May 2013 00:52:11 UT

A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...

Parameterizing an Excel Spreadsheet

Thu, 16 May 2013 22:56:05 UT

I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically...

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

When the person you hire is not the person you hire

Thu, 16 May 2013 21:00:26 UT

This is something I just heard about recently, but then experienced it for myself. This story was told to me: A...

My 2013 SQL Saturday Schedule!

Thu, 16 May 2013 20:02:07 UT

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...

Bill Gate’s speech

Thu, 16 May 2013 19:54:51 UT

One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...

Len() and DataLength()

Thu, 16 May 2013 19:00:56 UT

Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...

Magnify SQL Text with SSMS 2012

Thu, 16 May 2013 19:00:48 UT

This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....

Rated R (A Teaser)

Thu, 16 May 2013 19:00:05 UT

How many lines of TSQL codes and Window Functions you need to come up with this? With R, it takes about...

Lost Phone, Ring,Glasses,Etc, At the Office

Thu, 16 May 2013 17:31:43 UT

If you work at a company with more than a 100 or so employees you probably get an email every...

From Google Reader to Feedly

Thu, 16 May 2013 17:11:04 UT

I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...

DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions

Thu, 16 May 2013 16:57:00 UT

sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx Returns information about transactions at the database level. Some time , T-log...

Dragging a name from the object explorer to a query window

Thu, 16 May 2013 06:00:00 UT

In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...

The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports

Thu, 16 May 2013 06:00:00 UT

SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of...

Get Just The Tools: SSMS Download

Wed, 15 May 2013 23:00:04 UT

Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason,...

SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server

Wed, 15 May 2013 21:10:16 UT

We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...

Not My Google Reader Replacement

Wed, 15 May 2013 20:33:50 UT

Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign...

Email Response: SQL Server 2012 Planning and Architecture

Wed, 15 May 2013 20:11:08 UT

I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...

Job Schedules – SQL Agent

Wed, 15 May 2013 06:07:12 UT

This info should be easier to get than it is. Keep in mind that for something to run the subscription...

Table Sizes

Wed, 15 May 2013 06:03:05 UT

Although this isn’t guaranteed to be 100% accurate, it’s fast and usually extremely close if it’s not perfect. You can...

DTA and Hypothetical Indexes

Wed, 15 May 2013 06:00:00 UT

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...

Index Columns and Names

Wed, 15 May 2013 05:58:47 UT

Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...