Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...
2017-08-18
3 reads
Si vis pacem, para sql
Using Time Zones in SQL Server
The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...
2017-08-31 (first published: 2017-08-18)
3,783 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
210 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
16 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...
2017-08-01
59,905 reads
RegEx in SQL Server for searching text
As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations,...
2017-07-24
41 reads
RegEx in SQL Server for searching text
As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding some strings/sub-strings in the text columns. In such situations,...
2017-07-24
102 reads
RegEx in SQL Server for searching text
As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding...
2017-07-24
3,458 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
2 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
3 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Varchar(max) to lines
I have an issue with a varchar(max) field with up to 7000 characters needing...
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers