2017-11-16
757 reads
Devendra Thakur
- Interests: Bikes, XBox, Beaches and AI
2017-05-23
952 reads
2017-05-01
894 reads
SQL Server Free eBooks, Softwares, Tutorials and Websites
When we start working as developer or learning, we often
face this issue. Where is the best tutorials, books and other...
2017-04-10
295 reads
Alter Datatype of All the Columns In Database
Requirement: Recently we got the information from management
that our project will be getting the customers from China, so our application
should...
2017-03-28
162 reads
SQL Server Tips and Tricks
In this article I will be listing the tips and tricks to work like
a Pro.
So let's get started –
Important keyboard...
2017-02-20
298 reads
Part 2 - Detecting and Monitoring Memory Pressure Using DMV
I will be writing
this article in four parts because this topic is huge and the amount of
information can be overwhelming...
2017-02-06
564 reads
Altering Data Length of a Primary Key Column
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
964 reads
SQL Server - Monitoring Table Size
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
702 reads
Special Index - XML Index
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
511 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers