12 Things To Check With SQL Server To Prepare For Winter

Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...

12 Things To Check With SQL Server To Prepare For Winter

Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve...

Friday Followup For November 14, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

How to replace a specific string from a large string with Write feature ? TIP #72

 
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...

Memory consideration (Windows + SQL)

We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...

PASS Summit 2014 Wrap Up

This past week of conferences was simply amazing. It was the best week of my career. Period. Now that I’m...

Reblog: November 7 to November 13

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...

Update all SSRS reports to apply consistent header / footer on demand

Teaching good old SSRS a new trick…

Background
Not too long ago I had a client with a very simple, yet practical requirement: they...