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,331 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,331 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
435 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
60 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,481 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
22 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
31 reads
SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...
2017-12-28
902 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
10 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
15 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,793 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
hi , a new user wants to be able to add sql agent jobs...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers