Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2012

thanks for Bud

My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I am barely able to talk about it and may never be for all I know.

My Dad was a very special man. One that I did not appreciate until I… Read more

0 comments, 481 reads

Posted in @chuckboycejr on 22 November 2012

SQL Server 2012 SP1 CU1 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site.

SQL Server 2012 SP1 CU1 contains fixes released in SQL Server 2012 RTM CU 3 & 4. For those who are upgrading to Service Pack 1 from SQL… Read more

0 comments, 977 reads

Posted in MSSQLFUN on 22 November 2012

SQL Server 2008 SP3 CU8 Is Now Available !

The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 SP3.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 475 reads

Posted in MSSQLFUN on 22 November 2012

Newsletter

Back in the old days before this blog when I was publishing a website instead that has long been consigned to the website dustbin I had a newsletter. It had a few subscribers and was generally well received, since I moved to the blog platform back in 2009 I let… Read more

0 comments, 436 reads

Posted in The SQL DBA in the UK on 22 November 2012

Using Facebook to extend/enhance your blogging

I read a blog a few months ago by Ramkumar Gopal (blog) in which he had setup a Facebook page to record and post things that he doesn’t want to create a blog post for. I thought this was a really good idea for a whole host of… Read more

0 comments, 360 reads

Posted in SQL Server Rocks! on 22 November 2012

MDX #21 – Days in a month

ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods

ParallelPeriod() function is often used when we need to present data side-by-side for two parallel periods, such as in the example below where daily data needs to be presented side-by-side for each day in… Read more

0 comments, 221 reads

Posted in Sherry Li's BI Corner on 22 November 2012

MDX #20 – Last Data Date

Need to check the last time when our ETL processes ran successfully

Data warehouse developers routinely query the last data date (the last date when we have fact data) to check the last time when our ETL processes ran successfully.

It’s not hard to do it in TSQL. It just… Read more

1 comments, 214 reads

Posted in Sherry Li's BI Corner on 22 November 2012

Notes from SQLSaturday #168 in Tampa

I made a quick trip to Tampa for #168 this past weekend. It was a “BI Edition” and it felt less intense but still a great value, four tracks of content and about 150 attendees. I arrived in time to sit through most of a presentation by Mike Antonovich, and… Read more

0 comments, 496 reads

Posted in SQLAndy on 21 November 2012

Explore file physical structure - Delete


1. Create sample db

use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test_log.ldf' , SIZE = 1024KB , FILEGROWTH =…

Read more

0 comments, 1,275 reads

Posted in James' SQL Footprint on 21 November 2012

Most Interesting People…

Here are the most interesting people I met at PASS Summit 2012

 

Mickey Stuewe (sqlmickey)

Neil Hambly (neil_hambly)

Bob Hovious

Gail Shaw (sqlinthewild)

Ed Watson (SQLGator)

 

 

 

 

 

This is the short list of the many many many… Read more

0 comments, 586 reads

Posted in SQL RNNR on 21 November 2012

How to Use xp_delete_file to Purge Old Backup Files

Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to purge old backup files from a folder.  This is stored procedure used by the maintenance plans to clean up old backup files, but it makes for a handy purge tool…

Read more

0 comments, 285 reads

Posted in Everyday SQL on 21 November 2012

Final 2012 Learning Opportunity

There’s still a little time left in the year. I know some businesses have allocated training budgets and if they don’t spend the money, they lose it from their budget. So a few of you might still be looking for opportunities to get your learn on. I’ve got one more… Read more

0 comments, 503 reads

Posted in The Scary DBA on 21 November 2012

Top 3 Books on Writing Transact-SQL (TSQL)

This weeks blog posts have been focusing on books that I have read, like and recommend for learning SQL Server 2008. I’m often asked what books do I recommend for learning SQL Server 2008 and I nearly always reply with a question “What area of SQL Server do you want… Read more

0 comments, 451 reads

Posted in The SQL DBA in the UK on 21 November 2012

blogging fun: dealing with spammers like Psychz Networks

@PsychzNetworks is spamming me non-stop. Every minute of every day.

I googled them and it seems Psychz Networks are famous for spamming people.

I have removed non-moderated comments (I didn't want to do this and have since added non-moderated comments back) - didn't stop Psychz Networks' spam.

I have… Read more

1 comments, 757 reads

Posted in @chuckboycejr on 21 November 2012

PASS Summit 2012 Recordings Available

Did you attend PASS Summit and miss out on some sessions because there were so many or you were busy networking?  Good news!  The recordings are now available for free to watch streaming for all those who attended the conference now here.

If you weren’t an attendee you can… Read more

0 comments, 794 reads

Posted in Devin Knight on 21 November 2012

CTEs beyond SELECT

The other day I was writing a query to pull some DMV information and I ended up using several CTEs in my query before I was done. My plan was to dump the information into a table to process it further. I’m used to just throwing an INSERT INTO command… Read more

2 comments, 466 reads

Posted in SQLStudies on 20 November 2012

Newer posts

Older posts