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 them are self-explanatory, i.e. the name of the query/script...

2018-12-05

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)

5,016 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 aimed for the beginner-level T-SQL developers. Always Use a...

2018-11-17

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,397 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 and onward. Vulnerability Assessment (active from SSMS 17.4) Right...

2017-12-28

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

862 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 run in different time zones. Services have to consider...

2017-08-18

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,978 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 SQL Server using regex, and now I’m showing how...

2017-08-01

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

23,470 reads