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

Latest Blog Posts

Houston TechFest 2014: SQL Admin Best Practices with DMV's

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much for attending! There were some exceptionally useful questions raised today, great job to my audience.

Here is the .zip file as promised for my presentation slide deck and .sql…

Read more

0 comments, 78 reads

Posted in SQL Tact on 13 September 2014

SQLSaturday Orlando Marketing Plan-Part 42

  • Reg count at 479. Looking very good for hitting 500!
  • First sponsor sent out a geo-targeted message for us, another one working on it, more to go. We wrote a ‘suggested’ message to decrease the friction. First vendor even sent back open rates on the email!
  • Karla/Shawn dropped in at…

Read more

0 comments, 111 reads

Posted in SQLAndy on 12 September 2014

Reblog: September 5 to September 11

Photo credit – JStove

Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more

1 comments, 64 reads

Posted in StrateSQL on 12 September 2014

Professional Microsoft SQL Server 2014 Administration

Hello Dear Reader!  Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional Microsoft SQL Server 2014 book by Wrox.  We worked throughout the CTP phase and solidified the book after RTM.  By the end of July all the pages were in, all…

Read more

0 comments, 79 reads

Posted in SQLBalls on 12 September 2014

Friday Followup For September 12, 2014

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

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Automated Source Control: A Librarian For Your Database Objects, Part 1

Read more

0 comments, 61 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 12 September 2014

Schema on Read vs Schema on Write

Schema on Read vs Schema on Write in Business Intelligence

When starting build out a new BI strategy.  There are more options now than ever before.  Gone are the days of just creating a massive star or snowflake schema to store THE data warehouse.  In today’s business, you need to… Read more

0 comments, 80 reads

Posted in Business Intelligence and Enterprise Architecture on 12 September 2014

PASS Virtual Chapter Events: September & October 2014

PASS Virtual Chapter Events: September 2014

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including… Read more

0 comments, 77 reads

Posted in Marc Beacom on 11 September 2014

SQL Server: Converting binary data to a hexadecimal string

Problem

I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data to a hexadecimal string characters?


Solution

Before SQL Server 2005, it was not possible to directly convert the binary data to… Read more

0 comments, 89 reads

Posted in Basit's SQL Server Tips on 11 September 2014

A Wonderful Weekend in Riyadh, Kingdom of Saudi Arabia, Speaking SQLGulf #1, Alfaisal University


Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave man from the Saudi Ministry of Higher Education, managed to organise a great inaugural event.  After the longest visa request process in my life, and twice, since originally his goal was to host this event in…

Read more

0 comments, 81 reads

Posted in The Database Hive for SQL Server DBAs on 11 September 2014

What are trace flags?

Trace flags are one of those things that I’ve heard about more and more over the last five or six years. But only in the past year or so have I started to understand what they are and how to use them. I want to start out by saying that… Read more

0 comments, 77 reads

Posted in SQLStudies on 11 September 2014

Identifying large queries using Server Side Traces

Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).

I know Extended Events have a lower impact but I like server side traces. Not only because once you’ve set one up, setting up others is very simple but also because… Read more

0 comments, 123 reads

Posted in The DBA Who Came In From The Cold on 11 September 2014

SQL – List Primary key and Concatenate composite Keys into a single row separed by comma

The following query lists all the Primary keys of all the table. 

OP has requested to list all PK and composite PKs and concatenate all it’s composite PK column values into a single row separated by comma hence this post.

 
SELECT TAB.TABLE_NAME,COL.COLUMN_NAME  
FROM 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS TAB,  
    INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE COL  
WHERE  
    COL.CONSTRAINT_NAME =…

Read more

1 comments, 81 reads

Posted in PowerSQL By Prashanth Jayaram on 10 September 2014

VMworld 2014 Wrap Up for Data Professionals

A few weeks ago I was fortunate enough to attend VMware’s VMworld 2014 conference in San Francisco, CA. The show was simply amazing. I spent the show mostly meeting with the different technology vendors and other consulting groups, and feel that the relationships created at this event will last a… Read more

0 comments, 87 reads

Posted in Technobabble by Klee from @kleegeek on 10 September 2014

September 2014 Las Vegas UG Meeting

Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in store for you from the people in Las Vegas. Let’s call this a preview for next week which happens to be… Read more

0 comments, 71 reads

Posted in SQL RNNR on 10 September 2014

Statistics in SQL Server

I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those for SQL Server 2014. The changes in the cardinality estimator can’t be ignored. If you want to talk about statistics, I’ll be presenting at Live360 in November on that topic… Read more

0 comments, 137 reads

Posted in The Scary DBA on 10 September 2014

T-SQL Tuesday #58 – Security Phrases

Today is once again TSQL Tuesday.  This month the event and topic are being hosted by Sebastian Meine (blog | twitter).  You can read all about the topic this month on his blog inviting all to participate.

Despite Sebastian being a real cool kid, I was not too… Read more

0 comments, 3,680 reads

Posted in SQL RNNR on 9 September 2014

Untested

The 2014 Apple keynote was today, with the announcement of the iPhone 6 and iWatch taking center stage. I was excited, with an aging iPhone 4S that needs to be replaced. I tuned in, expecting to watch the announcements while taking care of some busywork on the other monitor.

At… Read more

0 comments, 110 reads

Posted in The Voice of the DBA on 9 September 2014

[Off-Topic] Beating Childhood Cancer

Note: I feel this post is important enough to post across all my blogs.

September is Childhood Cancer Awareness Month here in the USA. Here are some statistics:

  • In 2014, an estimated 15, 780 children (ages 0-19) will be diagnosed with cancer in the USA.
  • In 2014, an estimated…

Read more

0 comments, 87 reads

Posted in Databases – Infrastructure – Security on 9 September 2014

It’s All Fundamentals

I’m learning how to speak German. Interestingly enough, you don’t start off reading dissertations. Instead, you begin by learning the names of things, Teller for plate, Buch for book. The fundamentals. I’m a third degree black belt in Ken Ryu Kenpo. But you don’t start that, or continue it, by… Read more

6 comments, 122 reads

Posted in The Scary DBA on 9 September 2014

24 Hours of PASS Preview: Zero to Hero (I'm the Zero)


Hello Dear Reader!  We are already away into the 24 Hours of PASS Summit Preview for 2014!  I don't know if you heard, but I have a pre-con at the PASS Summit!  More precisely SQL MVP Robert Cain(@arcanecode | Blog) had a great idea for a precon and…

Read more

0 comments, 86 reads

Posted in SQLBalls on 9 September 2014

Older posts