SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2009

SQL University: Authentication and Authorization

Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics of security for SQL Server. Since this is an introductory class, we're going to focus primarily on SQL Server itself, only delving into the operating system when we have… Read more

4 comments, 10,200 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 October 2009

Phil Factor SQL Speed Phreak Competition

If you have a database application that is running slowly, or is straining the server, what do you do? After you’ve eliminated the obvious malaises such as locking problems, do you buy more hardware, tweak the indexes, or do you rewrite the most hard-working queries until they run faster?

My… Read more

4 comments, 2,747 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 25 October 2009

Red Gate Has 10th Birthday

I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had less than ten people on their staff. At the time, I was running SQL-Server-Performance.com, and they were the largest advertiser on my website. Eight years later, Red Gate is now… Read more

3 comments, 358 reads

Posted in SQL Aloha on 24 October 2009

Tricks and issues Part 1

Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see the comments on his Blog. Great job and thank you Pinal for having such a wonderful site and sharing valuable information.

Found following information helpful to me today (*as I…

Read more

0 comments, 556 reads

Posted in Vinay Thakur on 23 October 2009

SSRS - Setting Default Parameter Values for Analysis Services Datasets

When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult to dynamically set default parameter that are passed into the dataset being used.  It turns out this is a lot simpler to do then many people think.  In this post… Read more

5 comments, 6,668 reads

Posted in Devin Knight on 23 October 2009

Some useful commands and sp I use for Transaction Replication:

I write several blog  about replication and mansion commands and stored procedure related to transaction replication, but I would like to dedicate one blog (series of blogs) which should have all these information.

>>Some useful commands and stored procedures

How it works:

Log reader agent stores the command and transaction…

Read more

0 comments, 1,183 reads

Posted in Vinay Thakur on 23 October 2009

Some useful commands and sp for Transaction Replication

This blog is having some useful commands we use for replication and troubleshooting.

>>Some useful commands and stored procedures

How it works:

Log reader agent stores the command and transaction into following tables.

1.      distribution.dbo.MSrepl_Commands 

eg. SELECT * FROM distribution.dbo.MSrepl_Commands 

--- commands for all transactions for replication for seqno or… Read more

0 comments, 9,767 reads

Posted in Vinay Thakur on 23 October 2009

PASS Summit One Week Away

It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009 PASS Summit. I’m as excited about this one as I was my first summit, maybe more so. I’m going to get to see a bunch of friends that I only…

Read more

1 comments, 531 reads

Posted in The Scary DBA on 23 October 2009

Just Submitted Session for South Florida Code Camp

I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for Intro to SQL Server Analysis Services and Hopefully it will get put on the schedule. The guys in SF always put on a great event ! See you there ! Read more

0 comments, 324 reads

Posted in Adam Jorgensen on 23 October 2009

SQLLunch – Accidental DBA and Performance Data Collector

If you haven’t had a chance to attend the SQL Lunch Live Meeting learning series then sign in Monday at 11:30 CST for our next meeting.  Barry Ralston will be presenting on the Data Collector. 

Speaker:  Barry Ralston

Time: 11:30 AM CST

Meeting URL:  https://www.livemeeting.com/cc/usergroups/join?id=3GBFMJ&role=attend

Add to Outlook Calendar Read more

0 comments, 788 reads

Posted in SQLDownSouth on 23 October 2009

Another Year, Another Missed PASS Summit

This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll gain and the networking opportunities you'll encounter. You know, a lot hasn't been said on the later, but let me throw my two cents worth in here (since we're… Read more

Download the Free eBook “The SQL Server Tacklebox”

Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts for the Day-to-Day DBA. This 240 page book, and accompanying scripts, is chock full of advice for DBAs, from novice to experienced.



The book focuses on these topics: Read more

0 comments, 559 reads

Posted in SQL Aloha on 23 October 2009

Not Pointing Fingers - Microsoft and Sidekicks

Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They were actually Oracle, Sun, and Linux servers that were at a Verizon data center. Microsoft bought Danger last year, and when they had issues, they spent time and resources… Read more

1 comments, 700 reads

Posted in The Voice of the DBA on 23 October 2009

Sydney SQL Server Users Group Draws Big Crowd

On Tuesday, October 13, I spoke at the Sydney SQL Server Users Group, presenting on “How to Get the Most Out of the SQL Server 2005/2008 Profiler,” the last of my seven presentations made on my Australia speaking tour.

The group meets the second Tuesday of each month at… Read more

0 comments, 457 reads

Posted in SQL Aloha on 23 October 2009

PASS Update #18

Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more visible. Please note that these reflect my opinions, and not an official position of PASS. I’m not campaigning for anything, but I figure I can’t talk about transparency without being… Read more

2 comments, 735 reads

Posted in SQLAndy on 22 October 2009

Book Review: The Board Book

I ordered the ' target=_blank>The Board Book from Amazon ($18) to try to get some ideas for how to do a better job as a member of the PASS Board of Directors. It’s not bad reading, though it focuses more on larger companies and the for profit side of things.… Read more

0 comments, 535 reads

Posted in SQLAndy on 22 October 2009

Notes from SQLSaturday #21 – Part 3

I thought I’d finish up the notes by listing things that went well and not so well:

  • Jack Corbett really helped me get things done, taking ownership of his tasks. All my regular volunteers and some new ones did a great job, good natured and hard working. Where we (I)…

Read more

0 comments, 498 reads

Posted in SQLAndy on 22 October 2009

2009 PASS Conference Side Quests

Barring any unforeseen issues like sudden death, I'll attend this year's 2009 PASS conference in Seattle. I'll arrive Sunday the 1st and leave Sunday the 8th. Of course, my main quest is to participate at the conference. During conference hours I'll be completely dedicated to gathering knowledge and getting questions… Read more

1 comments, 744 reads

Posted in Bill Nicolich on 22 October 2009

Logins no longer exists.

Today while checking the logins, just want to clear/clean logins which are no longer exists on NT domain.

To get the logins which are no longer exits run the following:

EXEC master.dbo.sp_validatelogins


It will show you the list of SID and logins which are not exists. And then after…

Read more

0 comments, 509 reads

Posted in Vinay Thakur on 22 October 2009

You Bet Your Life

Yesterday, Jonathan Kehayias wrote in his blog post " Have you got air in your spare.." about dealing with a flat time. He went on to compare spare tires to HA/DR planning. An excellent article and recommended reading. I wish to expand on Jonathan's discourse...(read more)

Read more

0 comments, 338 reads

Posted in SQLSequel on 22 October 2009

Newer posts

Older posts