Using DMV to identify members roles
Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...
2010-08-12
2,763 reads
Blog Posts
White Paper Wednesday – Bulk Report Generation with SSIS and SSRS 2008 R2
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-12
234 reads
White Paper Wednesday – Data-tier Applications in SQL Server 2008 R2
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
405 reads
24 Hours of PASS: Like Bacon for Chocolate
24HOP: Like Bacon for Chocolate
24 Hours of PASS is hip, it’s new…it’s serialized.
The September 15-16 24HOP is a sneak peek...
2010-08-11
685 reads
24 Hours of PASS: Summit Preview
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview...
2010-08-11
564 reads
A Chance to Win a Free Trip to the PASS Summit
Passing along this contest from Idera and MSSQLTips. I don’t do many plugs, but it’s a chance for someone to...
2010-08-11
789 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
751 reads
Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
388 reads
Registration Open for 24 Hours of PASS
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
342 reads
Sharing a Temporary Table
One of the things that I’ve often seen people do is build temp tables to hold data for each connection...
2010-08-11
2,146 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers