Pattern searches beyond ‘%string%’.
I was asked today to take a table with a social security column and put all 0s if the column...
2013-06-03
923 reads
Blog Posts
SQL Logical Query Processing Order
This probably applies more to beginners or people who have been using SQL for a while but have been wondering...
2013-06-03
513 reads
SQL Server – How to Detach a Database
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,155 reads
SQL Server 2014 – A new and exciting journey !!! “Into the cloud”
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,382 reads
SQL Server Events in the UK – June 2013
Oh my god, there are so many events happening this month it is crazy. I’m going to break with tradition...
2013-06-03
699 reads
Using PowerShell to move files to Azure Storage
I was searching all over the place to try to find out how to move files into Azure Storage. Most...
2013-06-03
2,385 reads
Power View Reporting on Multidimensional Cubes Released
I’m a little late to the celebration but on Friday some there was some exciting news regarding Power View was...
2013-06-02
953 reads
SQL Server – How to Insert Explicit Values Into An Identity Column
By default, SQL Server automatically assigns a value to the Identity Column for each new row inserted into the table....
2013-06-02
678 reads
Taking the Tabular Journey
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services....
2013-06-02
788 reads
9 resources not to be Skeptic about Big Data
2 years ago I posted “16 papers and original articles on Big Data” It’s now time to review and...
2013-06-01
39 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat Telp BCA KCP Cengkeh +62 838-4945-0961
Wa:083849450961 Jl. Cengkeh 21-21A, RT.7/RW.7, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus...
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers