Find the number of rows for a value, without querying the table

Dear all,Being a DBA, developers approach me with questions like can you run this query for me in production?Select *
FROM
[dbo].[FactInternetSales]
WHERE UnitPrice = 32.6

Lets, say the table contains...

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions...

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov...

SQL Server on Linux Series: Why?

As you all have heard, Microsoft is supporting Linux as a supported operating system for the next version of SQL...

SQL Server Wait Types Library – UPGRADED!

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...

Copying files from/to a container

Last week I was having an issue with a SQL install within a container and to fix I needed to...

DAX calculations with hierarchies: Set the order straight.

[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...

Installation of SQL Server vNext CTP on Linux Distribution CentOS 7

It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was...

Multiple usage of functions to ensure “value” is not null? – NO

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...

My Session about SQL Server Parameterization

 
Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the...