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

Archives: April 2013

Limit running Powershell script under specific path with AppLocker

Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path, it is different to maintain the script version, and it is hard to determine which script can be removed or kept on the server.

here is a solution,  you can save all…

Read more

3 comments, 476 reads

Posted in James' SQL Footprint on 28 April 2013

Inaugural SQL Saturday #175 Fargo Wrapup

Yesterday I had the opportunity to speak at the first ever SQL Saturday Fargo! Jason Strate (b | l | t) and his wonderful wife Sarah (t) and the rest of the team came together and coordinated the entire event. For a first event, this… Read more

0 comments, 288 reads

Posted in Technobabble by Klee from @kleegeek on 28 April 2013

Assorted Links for April 27, 2013

  • Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining an inventory of authorized devices/etc. Do you know all the servers running SQL and would you know if someone set up a new one?
  • Add this blog about servant…

Read more

0 comments, 393 reads

Posted in SQLAndy on 27 April 2013

SQL Saturday 215 Deck and Demos Live

Hello Dear Reader!  I'm up in Jacksonville for SQL Saturday 215. Today I'm presenting SQL Internals, Backups, and Recovery Models!  OH MY!  

I'm also going to be the MC for the SQL Iron Chef BI presentation today.  Before the festivities being I wanted to upload my deck and Demo, a…

Read more

0 comments, 304 reads

Posted in SQLBalls on 27 April 2013

Reblog: April 19 to April 25

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

1 comments, 424 reads

Posted in StrateSQL on 26 April 2013

Gulf Coast SQL Server Users Group Wrapup

Today has been quite the day! This afternoon I presented for the SQL PASS Performance Virtual Chapter and tonight I spoke to the Gulf Coast SQL Server Users Group. I presented my Virtualizing Business Critical SQL Servers presentation, and really enjoyed the conversation that we had. Thank you again,… Read more

0 comments, 289 reads

Posted in Technobabble by Klee from @kleegeek on 26 April 2013

A Rickety Stairway to SQL Server Data Mining, Part 11: Model Comparison and Validation

by Steve Bolton               

              Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind of disclaimer to the effect that I’m writing this in order to learn the material faster (while simultaneously providing the most underrated component of SQL Server some badly needed free…

Read more

0 comments, 1,244 reads

Posted in Multidimensional Mayhem on 26 April 2013

SQL PASS Performance Virtual Chapter Presentation

Today I was fortunate enough to be able to give a new presentation to the SQL PASS Performance Virtual Chapter called ‘It’s All About the Performance, Right?’ The feedback I have received has been overwhelmingly positive, and I would like to thank the coordinators and all of the attendees! Your… Read more

0 comments, 273 reads

Posted in Technobabble by Klee from @kleegeek on 25 April 2013

SQLIntersection conference wrapup

Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April 6, flew to Las Vegas for the new SQLintersection conference at the MGM Grand, and then flew to Chicago to speak at SQL Saturday Chicago. 

SQLintersection is part of a… Read more

0 comments, 364 reads

Posted in Technobabble by Klee from @kleegeek on 25 April 2013

5 SQL Server White Papers Every DBA Should Read

There are countless sources for information on SQL Server available today.  There are books, webcasts, conferences, and blogs.  With all of these sources, it is easy to forget that there are white papers available from Microsoft.  It is important that  we make an effort to read the white papers that… Read more

10 comments, 443 reads

Posted in StrateSQL on 25 April 2013

Consultants – Why pay more?

As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the extra money spent would be well worth it.  But that is not always the case, and sometimes who have to help them to understand, like most things in… Read more

1 comments, 645 reads

Posted in James Serra's Blog on 25 April 2013

SQL Lunch – GeoFlow: 3D Geospatial Visualization

Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.

Lunch Details

#75-GeoFlow: 3D Geospatial Visualization

Speaker: Julie Koesmarno

Add To Outlook: Add To Calendar

Date and Time: 5/10/2013 11:30:00 AM CST

BIO: Julie Koesmarno is a consultant in SQL… Read more

0 comments, 672 reads

Posted in SQLDownSouth on 25 April 2013

Adding Data to Filestream with T-SQL

I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact on your tables. This post will look at the table side of Filestream and how you get your binary data into the database.

Let’s assume you have a filestream… Read more

0 comments, 467 reads

Posted in The Voice of the DBA on 25 April 2013

Database Administration KPIs – 1/2


As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate my work?

In DBA world, we love “no news is… Read more

7 comments, 1,334 reads

Posted in DBA Philosophy on 25 April 2013

How to backup a SQL 2012 database directly to Windows Azure

It has been a little while since I posted something and I’ve been meaning to finish off this blog for a few weeks now, but I have been a little busy with the arrival of my 2nd son (and have been distracted by my new Alienware laptop!)… Anyway I recently… Read more

0 comments, 762 reads

Posted in SQL Server Rocks! on 24 April 2013

PowerSQL – Generate Only Index Script of All Tables or Specific Tables

Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to move two tables(data and index)to different drive all together a different filegroup.  This would give the best IO performance. Those two tables have ‘N’ indexes. Manually scripting ‘N’ index… Read more

1 comments, 417 reads

Posted in PowerSQL By Prashanth Jayaram on 24 April 2013

Identify the cause of SQL Server blocking

In my previous article (Different techniques to identify blocking in SQL Server) on, I discussed about locks and blocks, and presented you with an overview on how to troubleshoot and resolve blocks using dynamic management views and Activity Monitor. After I wrote this article, I… Read more

0 comments, 461 reads

Posted in Basit's SQL Server Tips on 24 April 2013

The Public Role – a potential high risk security concern for DBAs

The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level roles because in SQL Server, every database user is automatically assigned to the public database role, and you cannot remove public database role from SQL Server… Read more

0 comments, 1,349 reads

Posted in Basit's SQL Server Tips on 24 April 2013

SQL Server index related dynamic management views and functions (Part 2)

SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or more selected columns. SQL Server automatically creates indexes when you define a primary key or unique constraint. You can use indexes to manage and track rows in a table or… Read more

0 comments, 345 reads

Posted in Basit's SQL Server Tips on 24 April 2013

The 200 Billion Dollar Tweet

Hello Dear Reader!  Ever try to convince someone that they should be paying attention to Twitter?  A co-worker, Vice President of something or other, CMO, CEO, or CIO?  

I’ve had conversations over the years with many people as to why Twitter is important to their business.  If they don’t have…

Read more

0 comments, 583 reads

Posted in SQLBalls on 24 April 2013

Newer posts

Older posts