SQL Saturday #192 - Tampa
Come and join SQL Saturday Tampa in their new venue (HCC) now that they've outgrown K-Force!
Full Text Searches on Documents in FileTables
SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. As with most technologies, the best way of learning them is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.
Data Profiling with T-SQL
Need to understand new data? This article explains why - and how you can profile it efficiently
Deploying Databases to the Azure Cloud: an extended plea
Is there a sound technical reason why SQL Azure can't support extended properties?
The Dark Side
Steve Jones talks a little about Oracle after speaking at an event devoted to that technology.
Backing Up SQL Server Databases Participating In Availability Groups
So I am using this new technology called Availability Groups that was introduced in SQL Server 2012. I have heard I can offload my backups to a secondary replica, but I am not sure how that works or how to configure those backups. Are there any limitations? Check out this tip to learn more.
Early Software
This week Steve Jones reminisces about the first software he used. He asks you what inspired you to start working with computers.
PowerShell Basics
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
NoSQL for the MSSQL Soul
The buzz around NoSQL solutions has reached stratospheric heights. This buzz has led many Microsoft SQL Server development shops to start looking at how and where a NoSQL solution can fit into their business.
Filtered Indexes - Simple Partitioning without Enterprise Edition?
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Alamat Kontak Bank BCA KCP Pati Telp:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers