SQLServerCentral.com Content tagged Blogs

How to hide Placeholder in SSRS 2008?

Sat, 11 Feb 2012 19:33:00 UT

Introduction For the ones who are working with SSRS, Placeholder is not new for them. So, today I will not go...

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

Hardware Fun

Sat, 11 Feb 2012 01:40:00 UT

This has been a bit of a hardware week for me, which is strange. I used to love hardware, building...

SQL Azure

Fri, 10 Feb 2012 23:00:31 UT

SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...

Behemoth of the Server Room?

Fri, 10 Feb 2012 22:15:00 UT

Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about...

Thanks to Brian Kelly for a Great Presentation on Auditing for SQL Server - Please Find the Notes Below

Fri, 10 Feb 2012 21:32:00 UT

For those interested in following a great MVP who contributes regularly on Infrastructure and Security, here are notes I took...

The Future of SQL Server Monitoring
"Being web-based, SQL Monitor
enables you to check on your servers
from almost any location" Jonathan Allen.
Try SQL Monitor now.

Powershell default start directory

Fri, 10 Feb 2012 21:21:09 UT

This post discusses some methods in configuring the Powershell default start directory By default , the installation process will add a value...

Slides and Scripts from Idera February webcast

Fri, 10 Feb 2012 20:03:00 UT

For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera: Presentation (.PDF)Scripts (.ZIP) If...

Review: I Done This

Fri, 10 Feb 2012 19:41:29 UT

IDoneThis is a simple web site for tracking accomplishments. The premise is that you get a checkbox on the calendar...

Notes from the February Space Coast SQL Meeting

Fri, 10 Feb 2012 19:25:27 UT

I drove over to Melbourne last night to the new home of Space Coast SQL at the Harris Institute for...

A Script A Day - Day 10 - Hosts on vCentre

Fri, 10 Feb 2012 15:46:00 UT

If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...

Executing scripts with sp_addscriptexec

Fri, 10 Feb 2012 13:42:47 UT

Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec...

AlwaysOn: Configuring Secondary Read-Only Access

Fri, 10 Feb 2012 07:00:00 UT

Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...

Data Page math : 96 + 8060 + 36 = 8192. is this correct?

Fri, 10 Feb 2012 05:39:00 UT

I have come accross interesting puzzle yesterday on numbers 96 and 36. Everyone knows that header size is 96 and maximum...

An open letter to anyone with “SQL Server” on their resume

Fri, 10 Feb 2012 04:20:50 UT

Dear Sir or Madam, I have your resume here in my hand and couldn’t help but notice that you have listed...

A Script A Day - Day 9 - Index Compression Estimations

Thu, 09 Feb 2012 20:34:00 UT

Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...

Stages of the Game?

Thu, 09 Feb 2012 19:30:18 UT

Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...

SQL Server Product Life Cycle

Thu, 09 Feb 2012 14:48:47 UT

Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range. The...

The Future of SQL Server Monitoring
"Being web-based, SQL Monitor
enables you to check on your servers
from almost any location" Jonathan Allen.
Try SQL Monitor now.

February #Meme15 Assignment

Thu, 09 Feb 2012 08:35:00 UT

It’s been a couple months now since a number of us got together to share how we use social networks...

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

SQL Server 2012 (“Denali”): Data Quality Services

Thu, 09 Feb 2012 07:00:00 UT

Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...

Whitepaper – Extending Reporting Services with Custom Code

Thu, 09 Feb 2012 05:29:17 UT

Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing...

[Shameless Plug] Can We Have Your Vote?

Thu, 09 Feb 2012 03:17:05 UT

[Shameless Plug] Can We Have Your Vote? SQL PASS SQLRally Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...

What is Microsoft Connect?

Wed, 08 Feb 2012 23:00:20 UT

Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...

An Unclassy Error

Wed, 08 Feb 2012 22:31:00 UT

I saw this on a TV while walking through a store. More than a but amusing, but not too helpful...

My upcoming speaking engagements

Wed, 08 Feb 2012 22:04:53 UT

In the last weeks it was very silent on my weblog, but life is pretty fast in 2012. Currently I'm preparing...

A Script A Day - Day 8 - Non Clustered Index Information

Wed, 08 Feb 2012 22:01:00 UT

Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...

Goals 2012

Wed, 08 Feb 2012 21:00:30 UT

As I have wanted to do each year, here is my goals post for 2012. Last year I set out...

Not enough storage is available to complete this operation

Wed, 08 Feb 2012 14:27:40 UT

This message appears in the TDP SQL dsmsched file. It’s usually associated with low levels of contiguous memory BackupVirtualDeviceSet::SetBufferParms: Request large...

RYO Maintenance Plan – Database Backups, Part 3

Wed, 08 Feb 2012 07:00:00 UT

4 out of 5 DBAs agree I’ve covered creating my backup directories and the actual backup of the database(s). The last...

Computed Columns and Divide by Zero

Wed, 08 Feb 2012 03:28:00 UT

I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...

SQLBits9

Wed, 08 Feb 2012 02:54:12 UT

SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...