Wait Statistics on a Query
Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...
2018-02-14 (first published: 2018-02-05)
2,766 reads
SQL Homework – February 2018 – Work with security
This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts
Create a SQL login and a Windows authenticated login....
2018-02-05
315 reads
Forensic Analysis of Log files in SQL Server
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...
2018-02-05
3,477 reads
Giving back – Speaking Mentors
I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...
2018-02-05
340 reads
PASS Summit 2017 Wrap-Up - The People!
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
12 reads
Power BI with Azure Data Lake - where the water doesn't run dry
(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...
2018-02-04
736 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out...
2018-02-04
550 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS...
2018-02-04
9 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...
2018-02-04
93 reads
Re-Imagining an SSIS IDE
Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...
2018-02-04
92 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers