Security Questions: Authentication Performance
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-28
758 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,082 reads
Business Intelligence Requirements Gathering
There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):
Identify...
2013-05-28
4,900 reads
Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
997 reads
Using CROSS APPLY to calculate an aggregate across a single row.
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,481 reads
SQL Server – Filtering objects in Object Explorer – Management Studio
When you are working on a database with a large number of objects sometimes it becomes a challenge to locate...
2013-05-28
1,026 reads
Using the SSIS Object Variable as a Result Set Enumerator
In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services,...
2013-05-28
1,886 reads
Investigating Plan Cache Bloat
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,141 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
613 reads
Sum Result of SSRS LookupSet Function
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return...
2013-05-27
7,553 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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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