Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
301 reads
Azure SQL Database Managed Instance is now private preview
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
308 reads
Packt $10 Sale
One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...
2018-03-06
346 reads
Table Internal Sync Rule–Substituting the Sync Column
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-06
391 reads
Book Review: SQL Server 2017 Machine Learning Services With R
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,720 reads
Identify the owner and then change the owner of a SQL Agent Job
In this post and video you will learn how to identify the owner and then change the owner of a...
2018-03-16 (first published: 2018-03-06)
22,056 reads
Classifying your data in Azure SQL DB for GDPR
Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...
2018-03-06
441 reads
2.5 Ways Your ORM Is Vulnerable To SQL Injection
Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don’t...
2018-03-16 (first published: 2018-03-06)
2,854 reads
2.5 Ways Your ORM Is Vulnerable To SQL Injection
Someone recently told me that they don't need to worry about SQL injection because they are using an ORM.
Oh boy.
ORMs don't automatically prevent SQL injection
Watch this week's video on YouTube
Object-relational...
2018-03-06
26 reads
Profiler for Extended Events: Quick Settings
As of SSMS 17.4 we have been given the ability to control XEvents Profiler just a tiny bit more. For what it is worth, we as Database Professionals love...
2018-03-05
30 reads
Blogs
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...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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