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 already describes its purpose. However, if you need to get some Continue reading Useful T-SQL queries and scripts to work in SQL Server
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 Schema for the Programmable Objects For example, instead of writing BillOfMaterial Continue reading How to Write a Better T-SQL Code
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 click on a database Tasks -> Vulnerability Assessment -> Scan For Continue reading Some New Cool Features in SSMS
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 the time zones. Applications’ users nowadays, which are around the globe Continue reading Using Time Zones in SQL Server
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 to use it for replacing text in SQL Server. The two Continue reading RegEx in SQL Server for replacing 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 we usually make two or more of queries in order to Continue reading RegEx in SQL Server for searching text
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 Educational and Development Center (SEDC), so I’m very thankful to SEDC. Continue reading Microsoft Certified Trainer!
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up to talk about dates and times, and converting them to string representations. Continue reading Some stuff with Date and Time in SQL Server
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts NULLs. The code is given in the next screen shot. ScreenShot Continue reading Multiple usage of functions to ensure “value” is not null?!
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of a table or index. There is a bit column in the sys.databases Continue reading Mixed page allocation