T-SQL for UDFs

SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...

10 Years of Blogging

Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...

MongoDB -Access different databases and Collections

You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query...

PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service

The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...

Rebuilding a Heap–Don’t Do It

I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but...

Temporary Post Used For Theme Detection (7bc987a8-70ff-4bce-b0b5-d4bad4ef7912 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Why is my SQL Server using all of the RAM on the server?

The TL;DR on this is simple:

"BECAUSE IT'S SUPPOSED TO!"

A frequent complaint we receive comes from a client that has an...

Alter Event Session

Ready for a change of pace? Good! Today is a really good time to start looking into one of the...

Learning R: Hitting the Books

I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...

Parallelism setting in SQL Server – reduce CXPACKET waits?

This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J

Let’s...