Parsing HTML in SQL Server
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few...
2019-02-12
2,293 reads
Blog Posts
Passion, Challenges, and SQL
One of my biggest reasons why I do what I do, boils down to the challenges that I frequently get to encounter. There is a wild satisfaction to working...
2019-02-12
5 reads
Passion, Challenges, and SQL
TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...
2019-02-12
792 reads
Power BI Monthly Digest – February 2019
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2019-02-12
1,042 reads
SQL Server Always On Read Only Routing Lists
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,617 reads
There’s got to be a better way
For T-SQL Tuesday #111, Andy Leonard asks “What is your why? Why do you do what you do?”
Like Andy, I...
2019-02-12
664 reads
T-SQL Tuesday #111 – What is My “Why?”
This month for T-SQL Tuesday we are asked to describe our “Why”. I have a couple of Whys not related...
2019-02-12
677 reads
T-SQL Tuesday #111 - Why Do You Do What You Do?
This month's T-SQL Tuesday is hosted by Andy Leonard (blog/@AndyLeonard) and his topic was this:
That’s the question this month: Why...
2019-02-12
123 reads
T-SQL Tuesday #111 – Why I blog
This month’s T-SQL Tuesday is hosted by Andy Leonard at andyleonard.blog . Andy asks us, what is your “Why?”
So what is...
2019-02-12
686 reads
What is your why? – T-SQL Tuesday #111
In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...
2019-02-12
11 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers