DevOps Basics–Creating a local repo and committing files
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-11
592 reads
Blog Posts
Dynamic SQL and the joys of QUOTENAME
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...
2017-05-11
651 reads
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...
2017-05-11
13 reads
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...
2017-05-11
60 reads
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...
2017-05-11
558 reads
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...
2017-05-11
11 reads
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...
2017-05-11
768 reads
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?...
2017-05-11
373 reads
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...
2017-05-10
2,139 reads
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...
2017-05-10 (first published: 2017-04-30)
4,808 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers