Creating Your Own Custom Data Collections
Continuing his discussion on SQL Server 2008 Data Collections, Greg Larsen explains how to create your own custom Data Collections.
2009-02-02
2,538 reads
Articles
PASS Update #3
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in one post, but I'll try to hit the highlights. The main event over the past two weeks was my first board meeting in Seattle. I arrived Monday afternoon
2009-02-02
1,001 reads
Semantically Controlled Any-to-Any Data Structure Reshaping
ANSI SQL can perform breakthrough any-to-any hierarchical data structure reshaping. These are transformations that are performed utilizing only the structure semantics in the data assuring correct semantic results.
2009-02-02
1,284 reads
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
2009-01-30 (first published: 2008-02-20)
34,613 reads
Business Intelligence and a Culture of Analysis
Public sector agencies very often need to work at ensuring that their corporate cultures establish a high value on, and properly reward, a push toward analysis.
2009-01-30
2,758 reads
Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some changes, then begin writing the book.
2009-01-30
101 reads
It's Your Ship
I saw this book ( It's Your Ship ) in a Barnes and Noble and the title and cover attracted me. So I picked it up and read the back, thought it was interesting, and later grabbed it for the Kindle.
2009-01-30
1,760 reads
SQL Server security settings using the Surface Area Configuration tool (SAC)
Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?
2009-01-30
2,589 reads
Celebrating A Million
SQLServerCentral crossed the 1 million member mark yesterday and we have a few things in mind for a celebration.
2009-01-29
2,834 reads
Configuring Replication for Partitioned Tables Using T-SQL
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
2009-01-29
6,513 reads
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers