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

Archives: November 2013

Myths and Misconceptions about Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Over the last weeks and months, I invested a lot of my time to get a better understanding of Hekaton – the new In-Memory technology that will be part of SQL… Read more

0 comments, 2,394 reads

Posted in Klaus Aschenbrenner on 30 November 2013

What’s In My Utility Belt? Issue #2

Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility Belt?”? Time flies when you’re having fun. Or when you’re really busy. A lot has happened since that first issue – I became, once again, a Rockstar Blogger, I… Read more

0 comments, 230 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 November 2013

Getting the read/write ratio for a database

EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below by adding extra columns to give the data more context and general advice when interpreting this type of data.

Just a quick post this time. Recently I needed to find… Read more

0 comments, 315 reads

Posted in SQL Server Rocks! on 30 November 2013

Understanding SQL Server related Windows Registries

SQL Server related information from Windows registries


The Windows Registry is a hierarchical database that stores configuration settings and options on Microsoft Windows operating systems. It contains settings for low-level operating system components and for applications running on the platform that have opted to use…

Read more

0 comments, 420 reads

Posted in Querying Microsoft SQL Server on 30 November 2013

Reblog: November 22 to November 28

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question.  It’s that whole “cha-ching” – buried treasure! feeling.  That’s kind of the aim of this blog post.  To provide… Read more

0 comments, 237 reads

Posted in StrateSQL on 29 November 2013

Digging Around For Free Tools – SQL Server

Tool Archaeology, Digging Through The Web

About every three to six months I will burn some time and just go digging for tools. Mostly, I’m looking for stuff related to SQL Server, PowerShell or C# development. There are lots of places to search through that could yield your next life… Read more

1 comments, 236 reads

Posted in SQL Man of Mystery on 29 November 2013

Friday Followup For November 29, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • 20 Abuses: Procedurally Going In Circles
  • Do You Need…

Read more

0 comments, 184 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 November 2013

Free Friday: Training

There are a number of good sites that offer free training and free E-Books. The community around MS SQL is amazing! If I forget anyone, please add an update. I'd like to have a complete list if at all possible. Let's break it apart for a second.

Before I start,…

Read more

3 comments, 268 reads

Posted in DBA On The Go on 29 November 2013

Throwback Thursday #2: Get Your Speak On!

I hope everyone is having a great Thanksgiving with their families. When you come out of that food coma I hope you enjoy my second blog post in the Throwback Thursday series. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some… Read more

0 comments, 164 reads

Posted in John Sterrett on 28 November 2013

A Rickety Stairway to SQL Server Data Mining, Part 14.6: Custom Mining Functions


by Steve Bolton

…………In the last installment of this amateur series of mistutorials on SQL Server Data Mining (SSDM), I explained how to implement the Predict method, which controls how the various out-of-the-box prediction functions included with SSDM are populated in custom algorithms. This limits users to returning the…

Read more

0 comments, 1,281 reads

Posted in Multidimensional Mayhem on 28 November 2013

Decrypting Stored Procedures Thanksgiving Special:Quick Tips

Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner now.

Happy Turkey day! Today we're going to eat, lounge around... and pray we're not called in. Something that I've found useful recently. You see a job calling a Stored…

Read more

4 comments, 2,437 reads

Posted in DBA On The Go on 28 November 2013

I’m A SQL Server Rockstar Blogger!

 

SQL Server Rockstar Blogger

I have a quick secret to share with my readers. Ever since I saw Tom Larock’s SQL Server Blogger rankings I have always wanted to be on that list. Today, that happened. To many it might seem like a small accomplishment towards bigger accomplishments. Right… Read more

4 comments, 234 reads

Posted in John Sterrett on 27 November 2013

Finding active DTS packages

DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS was the wave of the future. Everyone was so thrilled that posts like SSIS’ 15 faults and Why I hate SSIS: Part N+1 were all over the place, and I… Read more

0 comments, 1,546 reads

Posted in SQLStudies on 27 November 2013

Review: The Abilene Paradox

The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m doing for a project. The book is about management and is a series of stories/essays.  It’s not a book I’d recommend to a first time or first level manager, but… Read more

0 comments, 210 reads

Posted in SQLAndy on 27 November 2013

Master Data Services stops working after an upgrade

Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional. However, one of the instances also has Master… Read more

10 comments, 301 reads

Posted in Koen Verbeeck on 27 November 2013

Master Data Services stops working after an upgrade

Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional. However, one of the instances also has Master… Read more

0 comments, 141 reads

Posted in Koen Verbeeck on 27 November 2013

Connection pooling and the DBA

Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward. http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/10/08/connection-pooling-for-the-sql-server-dba.aspx Well, now and then I get approached with connection pooling issues and I’m like :| I plan to use … Continue reading

Read more

0 comments, 261 reads

Posted in Coffee and SQL on 27 November 2013

Identifying Columns to Create Index via T-SQL

To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL statement below; SELECT OBJECT_NAME(OBJECT_ID), mid.included_columns, mid.statement, mic.column_name, mid.equality_columns, mid.inequality_columns, mic.column_usage FROM sys.dm_db_missing_index_details mid CROSS apply sys.dm_db_missing_index_columns(mid.index_handle) mic ORDER BY mid.index_handle … Continue reading

Read more

4 comments, 398 reads

Posted in Coffee and SQL on 27 November 2013

Wasted Space Per Database For Fill Factor: Quick Tip

As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own stuff, I've found 300GB of space. That could be huge. Just simple things to think about. My previous post explains some things I've learned about Fill Factors, pros vs cons.…

Read more

2 comments, 1,292 reads

Posted in DBA On The Go on 27 November 2013

HammerDB SQL Server Benchmarking Utility

Mike Fal

Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance. A while back my friend Mike Fal (b | l | t) enlightened me on a different utility that he uses called HammerDB. He has… Read more

0 comments, 332 reads

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

Older posts