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
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,607 reads
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
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
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
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
SQLServerCentral crossed the 1 million member mark yesterday and we have a few things in mind for a celebration.
2009-01-29
2,828 reads
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
2009-01-29
6,495 reads
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
2009-01-29
4,546 reads
SQLSaturday #10 was held January 24, 2008 in Tampa at the Kforce Building. Attendance was about 175, down slightly from the year before. Overall the event turned out well; 36 sessions, everyone got fed, no major logistical challenges.
2009-01-29
662 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers