SQL Server on TLS 1.2: XEvent session to catch TLS in use
How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column...
2018-01-09
2,508 reads
Blog Posts
SQLpassion Online Training in January 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-01-09
374 reads
Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used
SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
964 reads
T-SQL Tuesday #098–Technical Challenges
It’s the first T-SQL Tuesday of 2018, being brought to you by Arun Sirpal. His invitation this month asks for...
2018-01-09
1,280 reads
T-SQL Tuesday #98 – Take Small Bites!
https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...
2018-01-09
555 reads
T-SQL Tuesday #98 – Your Technical Challenges Conquered – Corrupt Database in System Table
This T-SQL Tuesday is brought to us by Arun Sirpal (b | t) and wants to write about a technical challenge...
2018-01-09
150 reads
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
364 reads
Patching your SQL Servers - Meltdown and Spectre
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
623 reads
Python and SQL Server Administration
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server...
2018-01-08
823 reads
Roll on 2018!
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
367 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Bank BCA KCU PEKALONGAN Telp:0821°8200°203
Telp&Wa 628218200203 Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51116
Kantor Resmi BCA KCU MAGELANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
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