Introducing: The SQLUndercover Inspector
Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
Just another...
2018-01-22
506 reads
Server Audit Mystery 1: Filtering class_type gets Error Msg 25713
The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...
2018-02-01 (first published: 2018-01-22)
1,765 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
146 reads
Outlining (Day 22)
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
368 reads
The world of Automatic Tuning – SQL Server 2017
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...
2018-01-31 (first published: 2018-01-22)
2,425 reads
Database Fundamentals #16: Removing Data With T-SQL
Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.
How it Works
In the same way...
2018-01-31 (first published: 2018-01-22)
2,264 reads
Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
619 reads
SQL in the City is coming Feb 28
The next edition of the SQL in the City broadcast is coming Feb 28, and I’m planning travel now to...
2018-01-30 (first published: 2018-01-22)
1,317 reads
WIT: A Quick Thought
I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....
2018-02-02 (first published: 2018-01-22)
1,584 reads
What’s dbo?
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...
2018-01-29 (first published: 2018-01-22)
2,020 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