TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,529 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,377 reads
On how to Googlify your SQL statements for future searching
For sake of future generations, let’s begin to reduce typing and reuse code we’ve built. I think we can all...
2013-05-22
1,301 reads
View computed columns in database
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
578 reads
Get synonym definitions for all databases in server
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
816 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,605 reads
Calculating the next beginning of month and the current end of month
Handling dates is always a fun challenge in T-SQL! Finding the current end of month and next months beginning of...
2013-05-01
2,224 reads
snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
354 reads
Native SSMS a second class citizen no longer…
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
921 reads
dynamic sql and a char crash
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
432 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Adira Finance Lampung 1&2 Gatot Subroto. Tlp:08218168235
Jl. Gatot Subroto No.99l, Pahoman, Kec. Tanjungkarang Timur, Kota Bandar Lampung, Lampung 35226
BCA KCP KAS PASAR GEDE SOLO TLP/WA 083800209966
Jl. Utara Pasar Besar Utara No.1, Sudiroprajan, Kec. Ps. Kliwon, Kota Surakarta, Jawa Tengah...
BCA KCP Thamrin Nine TLP/WA 08216366654
Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10, Daerah Khusus...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers