This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Read more

Lets start discussing about this subject by closely looking at the term Redundancy.  What is redundancy all about ?

Wikipedia defines redundancy as “In engineering, redundancy is the duplication of critical components or functions of a system with the intention of increasing reliability of the system, usually… Read more

This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to centralized server. As I’ve already mentioned in my previous post PART1,  I’m explaining how to pull the  DATABASE BACKUP information from all listed instance

In order to execute the… Read more

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions of SQL Server? Have you tried running something like this on any of your Windows Azure SQL Databases yet:

EXEC sp_msforeachtable 'select ''?'', count(*) from ?'

Try it out.

Read more

It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting to 40404 for basic twitter usage on my Windows 6.5 Mobile. That seems miles away from the apps I know use on my current iPhone 4S. I almost can’t comprehend… Read more

The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more

This code demonstrates how to do an INSERT into SQL Server from a PowerShell script using an ADO.NET command object with strongly-typed parameters.  This script issues a DIR *.* command and inserts the results to the database.  While this example is not particularly useful, it is hopefully very simple and… Read more

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

When I first heard that Ed Wilson is writing a book on Windows PowerShell I was greatly excited. I am a great fan of PowerShell and by all means… Read more

by Steve Bolton

               I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around the time I got my Microsoft Certified Solution Developer (MCSD) certification in VB 6.0 (at precisely the same time .Net hit the market, instantly leaving me a year or… Read more

As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted… Read more

I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October 14-18.  It’s amazing to think that, although I have been in IT for 25 years, I first started to build my brand when I started this blog only… Read more

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

This is just a quick post to share a lesson learned while I was on an engagement where the client’s reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to SQL Server… Read more

Read more

I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate is investing in cloud tools, and more development tools, so it’s something I need to work on.

I went to the Azure page, and noticed a “Member Offers” link.

When… Read more

My latest article is up at MSSQLTips.com:

Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right

For more of my articles:

• My articles here at SQLServerCentral.com
• My articles at MSSQLTips.com

  Read more

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

Register to attend the webinar!

We're going to look at the typical ETL (Extract, Transform, Load) pipeline and consider the weak points… Read more

I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013.  If you weren’t you can now watch the recording here.

As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on… Read more

WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can do is keep repeating WOW. I’m in shock.

Even better, I was chosen for a spotlight session! I could not be more ecstatic! I received the email while I was… Read more