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

3 reads

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

1 reads

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

2018-11-17

1 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,406 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 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

868 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