SQL Server Window Functions in Action
SQL Server Window Functions were introduced in SQL Server 2005 with a basic set of operators and massively upgraded in...
2017-05-23
93 reads
A Busy Few Years
Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking...
2017-05-22
483 reads
Technology Gender Gap By State
This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...
2017-06-02 (first published: 2017-05-22)
1,431 reads
Employees, encourage work from home
The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one...
2017-05-22
417 reads
SSRS Custom Shared Schedule
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
Related Posts:
CRM Data Source Connection Error January...
2017-05-22
79 reads
SSRS Custom Shared Schedule
Reporting Services
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power...
2017-06-02 (first published: 2017-05-22)
6,869 reads
What’s in a partition?
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...
2017-05-22
512 reads
AD Authentication and Azure SQL Database
Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...
2017-05-22
424 reads
Tracking Lookup Operations in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-05-22
262 reads
Fischer’s Exact Test – with T-SQL and R
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,492 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