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,514 reads
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,514 reads
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,366 reads
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,290 reads
Snippet to quickly view computed column information. You can also view this by doing a “create table” script. This however,...
2013-05-22
565 reads
If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...
2013-05-21
803 reads
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,597 reads
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,205 reads
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
351 reads
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
907 reads
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
415 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers