Jack of ALL Trades
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
437 reads
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
437 reads
@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox
2018-01-18
378 reads
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
158 reads
Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well,...
2018-01-17
392 reads
Dynamic management views (DMVs) and dynamic management functions (DMFs) are system views and system functions that return metadata of the system...
2018-01-17
913 reads
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
343 reads
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...
2018-01-17
323 reads
A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always...
2018-01-17
790 reads
Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The...
2018-01-17
62,687 reads
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,132 reads
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item 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