2016-03-11 (first published: 2015-01-08)
19,040 reads
Articles
Five Online Database Modelling Services
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database designers. Are they good enough to use now? Robert Sheldon finds out.
2016-03-11
4,547 reads
Find a String in a String in SQL Server
Learn how you can find data in a string and extract it, no matter where it's located.
2016-03-10
42,387 reads
Getting Started with JSON Support in SQL Server 2016 – Part 2
Arshad Ali talks about using OPENJSON to read and parse JSON data and looks at how to convert it to tabular format.
2016-03-10
4,763 reads
Disabling SQL Server Optimizer Rules with QUERYRULEOFF
Daniel Farina shows how to disable the optimizer rules by using QUERYRULEOFF, an undocumented hint.
2016-03-09
2,891 reads
SQL GROUP BY Basics
It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives a quick revision of the GROUP BY and HAVING clauses in SQL that are the bedrock of any sort of analysis of data, and comes up with some nuggets that may not be entirely obvious.
2016-03-08
6,672 reads
Deep Dive into Changing Database Collation
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
2016-03-07
4,372 reads
Microsoft Data Driven SQL Server Event - Watch Live
Hear from Microsoft engineering experts on the latest features in SQL Server 2016 before the live event. Learn about new business intelligence capabilities like built-in mobile BI, fully integrated advanced analytics, security innovations, mission critical in-memory performance and new hybrid cloud solutions.
2016-03-07
3,159 reads
Performance Surprises and Assumptions : SET NOCOUNT ON
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance
2016-03-07
5,657 reads
Data Science for SQL Folks: Leveraging SQL and R
Learn about how to build value driven analytics with SQL Server and R.
2016-03-04 (first published: 2014-11-03)
16,083 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers