One way to get an index seek for a leading %wildcard
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
Human and Machine Learning
Machine learning and AI are becoming more and more prevalent, which Steve Jones thinks is good.
Performance Dashboard Error: Could not find stored procedure
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
The Secure Medical Data Challenge
This week Steve looks at the challenges of security for medical data.
Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data
SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.
The Last Week for SQL Bits 2017 Discounts
This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.
Enumerate Windows Group Members
Here a quick script showing how to get all the Active Directory users in a AD group.
Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g
If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.
The Cloud is Just a Tool
Today Steve Jones argues the cloud is just another tool for us to use. Not required, not ignored, but considered.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU RAWAMANGUN Hub.0821•3111•185
BCA KCU RAWAMANGUN Hub.0821•3111•185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
BCA KCP Citra 2 Ext TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02, RT.2/RW.8,...
BCA KCP Ebony - PIK 2 TLP/WA 08216977749
Pantai Kita, Soho Blok B.030, Unit SEB-030, Type Ebony 2 Jl. Pantai Indah Kapuk...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers