Monitoring BI Performance: Scripts and Slides
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...
2014-11-10
1,245 reads
Blog Posts
PASS Keynote–Dr. Rimma Nehme
I missed the PASS welcome, but I did arrive to see Cloud Databases from Dr. Rimma Nehme.
We begin with a...
2014-11-10 (first published: 2014-11-06)
5,324 reads
PASS Summit 2014: WIT Luncheon with Kimberly Bryant
Kimberly Bryant, founder of Black Girls Code
When Kimberly Bryant began studying programming at college, she found that there were few...
2014-11-10 (first published: 2014-11-06)
4,182 reads
Summit 2014
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS...
2014-11-10
465 reads
How to pause execution for particular time or interval ? TIP #71
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
284 reads
SQL PASS 2014 Summit Diary – Day 6
Today is the last official day of the PASS Summit. The sessions will wrap up at the end of the...
2014-11-08
847 reads
Working with Very Large Tables Like a Pro in SQL Server 2014
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,038 reads
Blogging for a year!
I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m...
2014-11-07
443 reads
Determine size of the file using T-SQL/Powershell/Ole Objects
There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...
2014-11-07
1,097 reads
Friday Followup For November 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-11-07
353 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers