Si vis pacem, para sql

Useful T-SQL queries and scripts to work in SQL Server

• by Igor Micev

• Si vis pacem, para sql

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...

2018-12-26 (first published: 2018-12-05)

4,638 reads

How to Write a Better T-SQL Code

• by Igor Micev

• Si vis pacem, para sql

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...

2018-11-28 (first published: 2018-11-16)

4,383 reads

Some New Cool Features in SSMS

• by Igor Micev

• Si vis pacem, para sql

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...

2017-12-28

858 reads

Using Time Zones in SQL Server

• by Igor Micev

• Si vis pacem, para sql

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)

1,949 reads

RegEx in SQL Server for replacing text

• by Igor Micev

• Si vis pacem, para sql

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...

2017-08-01

17,736 reads

RegEx in SQL Server for searching text

• by Igor Micev

• Si vis pacem, para sql

As a database developer or DBA, or even software developer, you must have met up with the difficulties of finding...

2017-07-24

726 reads

Microsoft Certified Trainer!

• by Igor Micev

• Si vis pacem, para sql

For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...

2017-05-28

422 reads

Some stuff with Date and Time in SQL Server

• by Igor Micev

• Si vis pacem, para sql

I’m writing this post because I want to put some more stuff around dates and times in one place. I...

2017-05-09

894 reads

Multiple usage of functions to ensure “value” is not null? – NO

• by Igor Micev

• Si vis pacem, para sql

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...

2017-05-10 (first published: 2017-04-29)

2,366 reads

Mixed page allocation

• by Igor Micev

• Si vis pacem, para sql

MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...

2017-04-08

1,649 reads