SQLServerCentral.com Content tagged Blogs

SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup

Fri, 24 May 2013 22:42:50 UT

This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...

Reblog: May 17 to May 23

Fri, 24 May 2013 21:00:22 UT

Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...

A Little Azure Fun on Friday

Fri, 24 May 2013 20:21:27 UT

You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions...

Performing an INSERT from a PowerShell script

Fri, 24 May 2013 17:48:00 UT

This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object...

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...

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.

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...

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...

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.

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...

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...

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...

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

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...

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...

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...

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...

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

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,...

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

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...

Speaking at PASS Summit 2013!

Wed, 22 May 2013 19:43:18 UT

I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting...

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.