What’s going on, on my server, right now?
Quick and easy way to monitor server activity and be notified from alerts.
2015-02-16 (first published: 2013-07-23)
21,598 reads
Articles
Managing Test Data as a Database CI Component - Part 1
Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.
2015-02-16
7,538 reads
Cascaded Parameters in SQL Server Reporting Services
You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.
2015-02-13
8,304 reads
SQL Saturday #371 - Tampa, FL
SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.
2015-02-13
7,335 reads
How to use the IsNothing Inspection Function in SSRS
SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.
2015-02-12
62,226 reads
SQL Bits XIV, London, March 4 – 7, 2015
SQL Bits is Europe's largest SQL Server conference. They have experts teaching beginners, and beginners questioning experts, providing feedback and improving the event every year. Register with the code SSC-HERO to get a 15% discount on the ticket price!
2015-02-12
388 reads
Bowled Over by SQL Window Functions
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.
2015-02-12
10,399 reads
Using SQL Server's GROUP BY clause to Summarize your Data
SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.
2015-02-11
12,133 reads
The Quickest Guide to Getting Started with PowerPivot
If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.
2015-02-10
5,642 reads
Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask
Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.
2015-02-10
12,511 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers