Youtube Channel Update: 3 August 2018
I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data...
2018-08-03
404 reads
I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data...
2018-08-03
404 reads
And the results of the poll are in!
Evening just scraping it! So there’s a pretty even mix out there, interesting....
2018-08-03
244 reads
In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...
2018-08-03
2,506 reads
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on...
2018-08-03
21 reads
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
2,121 reads
There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:
--
Log Name: ApplicationSource: MSSQLSERVERDate: 5/24/2018...
2018-08-20 (first published: 2018-08-02)
2,906 reads
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
38 reads
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
138,467 reads
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
268 reads
When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...
2018-08-16 (first published: 2018-08-01)
5,562 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