Scope: The drastic caveat with Logon Triggers.
In this article, Johan Bijnens shows how logon triggers can bite you in the back.
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
SQL Server 2008 Sparse Columns Identifying Columns For Conversion
SQL Server 2008 has introduced a new way to store data for columns that contain excessive NULL values called Sparse Columns. What this means is that when you declare a column as Sparse and any time a NULL value is entered in the column it will not use any space. Is there a way to identify what columns would make a good candidate for this without having to analyze each column individually?
SQL Server virtualization pros and cons
Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
SQLSaturday #10 - Tampa 2009
Looking for free SQL Server training?
Join over 250 SQL Server professionals in Tampa on January 24th, 2009 for SQL Saturday #10. Featuring 6 tracks and more than 36 SQL Server presentations, it's the biggest and best free SQL event available. Visit www.sqlsaturday.com to see event details and to register.
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers