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

Archives: April 2011

SQL University: SQL Azure & PowerShell

Welcome once more to the Miskatonic branch of SQL University. I see that most off you survived out last encounter… uh, class. Most of you even appear somewhat sane… somewhat. Today we’re going to talk about PowerShell and it’s use with SQL Azure. Which sounds a something like an… Read more

0 comments, 970 reads

Posted in The Scary DBA on 28 April 2011

How to determine the current SSIS runtime environment

If you want to test if you’re currently debugging an SSIS package via BIDS/Visual Studio, or running normally via DTExec, you can use the following utility functions inside a Script task.

    Public Function SSIS_IsBIDS() As Boolean

        Return (SSIS_Environment() = "DtsDebugHost")

    End Function

    Public Function SSIS_IsDTExec()… Read more

1 comments, 832 reads

Posted in New York City .NET on 28 April 2011

Powershell Day 28

Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn more aobut PBM http://blogs.msdn.com/b/sqlpbm/   Introduction:- Policy-Based Management (PBM).is introduced from sql server 2008 onwards. Policy means making a sql … Continue reading

Read more

0 comments, 169 reads

Posted in Vinay Thakur on 28 April 2011

Have You Heard? You Can Get a Mentor

Steve Jones and Andy Warren are at it again.  The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new program, The Mentoring Experiment, to try to match professionals (SQL Server only to start), with a more experienced professional as a mentor.  One of their goals is… Read more

0 comments, 332 reads

Posted in Wise Man or Wise Guy on 28 April 2011

MS Certs Exam price is rising …

Today Marlon Ribunal twittes come with new info about MS Certifications exams are rising…

This is not a good news, so if someone wants to catch the cheap price of the MS exams just do it during the next month. There is a nice possibility via Prometric – Microsoft to… Read more

0 comments, 282 reads

Posted in Dukagjin Maloku - Dugi'DBA on 28 April 2011

DevConnections – Heavily Discounted Passes !

DevConnections – London June 2011

DatabaseExpertise has negotiated 10 tickets for the main 2 day conference, at an amazing price of  £100!!!

The first 10 people to call Penton with their credit card details on 0161 929 2800, quoting MSD0611 – databaseexpertise.com;  will be registered

Come and hear from… Read more

0 comments, 299 reads

Posted in DatabaseExpertise.com on 28 April 2011

Daily Denali Delight – Day 6

Code-named Denali – the next version of SQL Server is fast approaching.

And whenever CTP2 gets released you can be sure to expect some excellent new features.

Here I continue to delve into these delights, highlighting those to look out for.

Juneau (New Development Environment)

Juneau is the code name… Read more

1 comments, 382 reads

Posted in DatabaseExpertise.com on 28 April 2011

SQL Monitioring Suite - Powershell Profile & Functions

 

I like to run Powershell from the windows OS. You can run it through SSMS if you wish, but I want to concentrate on the OS version. It’s just personal preference. I’ll be honest with you – when researching Powershell for the first time I came across an article… Read more

1 comments, 625 reads

Posted in Phill’s SQL Stuff on 28 April 2011

A SQL Server Hardware Nugget A Day – Day 27

For Day 27 of this series, I am going to talk a little bit about disk performance and one easy tool you can use to compare the performance of different types of disks and disk arrays.

CrystalDiskMark, available from Crystal Dew World  is a widely used I/O component…

Read more

0 comments, 642 reads

Posted in Glenn Berry's SQL Server Performance on 27 April 2011

It’s a Deal, It’s a Steal…

Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or Lock Stock, I forget. No prize on offer, but if you know which film its from leave me a comment with the answer.)

This phrase pretty much describes the deal… Read more

2 comments, 266 reads

Posted in The SQL DBA in the UK on 27 April 2011

Free Webcast Series: Patterns and Practices in Database Administration

SSWUG.ORG’s virtual webcasts will prepare the “Accidental DBA” for patterns and practices they will experience in their role as a database administrator. I will provide easy-to-understand insights and realistic examples for professionals who have not had any formal DBA training. By the end of our four-part series, you should have… Read more

0 comments, 171 reads

Posted in Kevin E. Kline on 27 April 2011

Connection strings and application name

G’day,

There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply things – as this tip is today.

DBA’s often have to track down problems – often performance related – and they tend to use profiler for… Read more

0 comments, 1,434 reads

Posted in measure twice, cut once. on 27 April 2011

What name should I call myself?

In creating this blog, I was thinking about using some catchy name for myself.  Something with “DBA” in it.  However, doing a quick Google search revealed there are so many already: Cranky DBA, Rambling DBA, Goal Keeping DBA, Mean Old DBA, Midnight DBA, Lone DBA Read more

0 comments, 350 reads

Posted in James Serra's Blog on 27 April 2011

Presenting On DR & HA Twice This Week

Just a quick mention that I'm presenting Paging DR Availability, You're Wanted in the Recovery Room twice this week  - today, April 27, at noon Eastern for the PASS DBA Virtual Chapter and Saturday, April 30, at SQLSaturday #74 in Jacksonville.

Register for the DBA Virtual Chapter presentation here,… Read more

1 comments, 171 reads

Posted in Kendal Van Dyke on 27 April 2011

What’s Mentoring?

We have just kicked off The Mentoring Experiment after talking about it for months. There has been a lot of interest and quite a few applications submitted. We’ve even had a lot of people ask if we needed help mentoring people, which is great. If you’re interested, you still have… Read more

0 comments, 498 reads

Posted in The Voice of the DBA on 27 April 2011

Powershell Day 27

Day 27 Inventory   As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as: To get the Operating related information win32_OperatingSystem :OS info PS C:\> get-wmiobject win32_OperatingSystem –computername “servernm” Or PS C:\> get-wmiobject … Continue reading

Read more

0 comments, 172 reads

Posted in Vinay Thakur on 27 April 2011

Microsoft Certification Exams: Costs are Increasing

It was announced yesterday that the cost of taking a Microsoft exam will increase from the 1 July. In the UK the price will be increasing from £88 to £99. A fair amount of my readers and visitors come for the USA. If you are taking the test across the… Read more

0 comments, 1,487 reads

Posted in The SQL DBA in the UK on 27 April 2011

Daily Denali Delight – Day 5

Code-named Denali – the next version of SQL Server is fast approaching.

And whenever CTP2 gets released you can be sure to expect some excellent new features.

Here I continue to delve into these delights, highlighting those to look out for.

Spatial Features

Not that I get to play around… Read more

2 comments, 374 reads

Posted in DatabaseExpertise.com on 27 April 2011

The developer / DBA relationship.

G’day,

A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as a developer before moving into database administration in 2008. Consequently,  I find this relationship to be one of the easier aspects of my job to manage  -… Read more

9 comments, 1,700 reads

Posted in measure twice, cut once. on 27 April 2011

A SQL Server Hardware Nugget A Day – Day 26

For Day 26 of this series, I want to talk a little about laptop processor selection (since I get a lot of questions about it).  Many DBAs, Developers, and consultants use laptop computers as their primary workstations for working with SQL Server. Even more than an actual database server,… Read more

7 comments, 544 reads

Posted in Glenn Berry's SQL Server Performance on 26 April 2011

Newer posts

Older posts