Latest Blog Posts
We’ve just wrapped up the interviews and I wanted to jot down a few thoughts on what I’ve seen from using the process that we have today:
- The time requirement for the NomCom members seems reasonable
- We still have a lot of work on explaining the “why” of the tasks…
I’ve been attempting to expand my reach to get back to my roots in development. I’m doing this because I really believe in the concepts behind devops, that these walls we’ve erected between development and dba, between dba and san admin, et, ad nauseum, cetera, need to come to an… Read more
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick.
That can mean that your PATH variable is tooooo long to fit some system functions - and SSMS crashes.
Question "Why one function allows to…
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be… Read more
Here is the .zip file as promised for my presentation slide deck and .sql…
- 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…
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
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
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
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
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?
Before SQL Server 2005, it was not possible to directly convert the binary data to… Read more
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
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
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 =…
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
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
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