Useful T-SQL queries and scripts to work in SQL Server
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)
7,187 reads
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)
7,187 reads
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
406 reads
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
20 reads
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,462 reads
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
7 reads
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
15 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...
2017-12-28
889 reads
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
3 reads
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
3 reads
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,647 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers