SQLServerCentral.com Content tagged Blogs

Connecting Windows Server 2003 VM To External Network In Hyper-V

Fri, 24 May 2013 18:00:37 UT

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical...

Per Member Per Month Per 1000 Calculations in MDX

Fri, 24 May 2013 06:00:00 UT

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...

Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Fri, 24 May 2013 04:52:00 UT

Today I will talk about a book titled ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc. When I...

A Rickety Stairway to SQL Server Data Mining, Part 13: Using CLR with Analysis Services

Fri, 24 May 2013 01:40:32 UT

by Steve Bolton I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around...

Security Questions: Differences between “Grant” and “With Grant?”

Thu, 23 May 2013 23:00:28 UT

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...

I’m presenting at the PASS Summit!

Thu, 23 May 2013 21:00:19 UT

I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October...

Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes

Thu, 23 May 2013 21:00:00 UT

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Business Objects on Linux and SQL Server

Thu, 23 May 2013 19:30:56 UT

This is just a quick post to share a lesson learned while I was on an engagement where the client’s...

Dedicated Administrator Connection (DAC)

Thu, 23 May 2013 19:20:00 UT

We all dread the scenario whereby SQL Server is under so much load and has a complete lack of resources...

Starting with Azure

Thu, 23 May 2013 17:17:00 UT

I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate...

DR planning article up at MSSQLTips!

Thu, 23 May 2013 13:05:00 UT

My latest article is up at MSSQLTips.com: Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right For more of...

Giving an SSIS security webinar with Andy Leonard

Thu, 23 May 2013 11:00:00 UT

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May...

Ad-hoc Reporting with SharePoint Recording and Q&A

Thu, 23 May 2013 08:38:02 UT

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If...

Speaking at SQL PASS Summit 2013

Thu, 23 May 2013 06:57:19 UT

WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can...

Azure does Powershell too

Thu, 23 May 2013 06:00:00 UT

Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...

The many uses of CROSS APPLY

Thu, 23 May 2013 06:00:00 UT

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...

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

The Bicentennial SQLSaturday–#200 Philadelphia

Thu, 23 May 2013 05:22:00 UT

When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a...

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

New On-Line Resources for Windows, Virtualization, and Cloud!

Thu, 23 May 2013 01:31:13 UT

Ever since returning from the UK for the SQLBits conference, I’ve been snowed under a mountain of action items. I’ve...

Database index design and optimization: Some guidelines

Thu, 23 May 2013 00:56:12 UT

Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response...

SQL Server Transactions and Locking (Part 1)

Thu, 23 May 2013 00:39:46 UT

In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...

Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)

Thu, 23 May 2013 00:33:37 UT

The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...

SQL Server index related dynamic management views and functions (Part 3)

Thu, 23 May 2013 00:20:37 UT

With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...

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.

Presenting 2 sessions at SQLPASS

Thu, 23 May 2013 00:18:32 UT

I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been...

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

We’re speaking at PASS Summit 2013!

Wed, 22 May 2013 23:21:28 UT

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...

Index Analysis May Update

Wed, 22 May 2013 23:00:50 UT

Seems I managed to make it through all of April without an update to the index analysis stored procedure. It...

Holy Schnikes I’m Speaking at PASS Summit 2013

Wed, 22 May 2013 23:00:26 UT

I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013...

PASS Summit 2013 is Looking Cloudy

Wed, 22 May 2013 22:14:31 UT

No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be...

View computed columns in database

Wed, 22 May 2013 21:42:28 UT

Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...

Speaking At the PASS Summit!

Wed, 22 May 2013 21:10:00 UT

I’m Speaking at The PASS Summit 2013! Hello Dear Reader! Big news. I’ve been selected as a speaker for the SQL...

Security Questions: Grant Permissions to All Stored Procedures

Wed, 22 May 2013 21:00:06 UT

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...