An Interview with Ralph Kimball
Ralph Kimball, founder of The Kimbaal Group, shares some thoughts on data with PASS.
Divide and Conquer
This is the first article by Steve Jones that examines a programming technique for handling operations that may be too large to run in a single query.
SQL Server 2005 Partitioned Tables and Indexes
Although partitioning tables and indexes has always been a design tactic chosen to improve performance and manageability in larger databases, Microsoft SQL Server 2005 has new features that simplify the design. This whitepaper describes the logical progression from manually partitioning data by creating your own tables to the preliminary features, which enabled partitioning through views in SQL Server 7.0 and SQL Server 2000, to the true partitioned table features available in SQL Server 2005. In SQL Server 2005, the new table-based partitioning features significantly simplify design and administration of partitioned tables while continuing to improve performance.
TeraTrax Offers The SQLServerCentral.com a 15% Discount
Teratrax, maker of SQL Server products, is offering the SQLServerCentral.com community a 15% discount on their products.
Unified Database Toolkit - Scheduling
SQL Server has a great scheduling system in SQLAgent. But sometimes SQLAgent won't work or isn't available. Author Andre Vigneau has built a solid system for auomtating the management of SQL Server, one that he deploys with the software that his company sells. Read about the basics of this system and get some code that might come in handy for you.
WebService - Enabling SQL Server 2005 Procedures
One of the most interesting features that I'll explore is that you can now create WebServices in the database tier directly, without resorting to "add ons" or even the use of IIS at all. One of the many extensions to Transact SQL is the new CREATE ENDPOINT statement, which allows the developer to create an endpoint directly from SQL Server 2005, which hooks right into the Kernel Mode HTTP.SYS driver, exposing functions and stored procedures written either in T-SQL or native CLR methods/classes.
Basics of C2 Auditing
Auditing in SQL Server is something that is becoming more and more prevelant, and will likely become more regulated over time. Dinesh Asanka brings us a new article on the basics of SQL Servers most powerful auditing configuration, C2 level auditing.
XML Support in Microsoft SQL Server 2005
This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client side programming support in the .NET Framework V2.0 and in native code such as OLEDB and SQLXML.
2004 SQLServerCentral.com Readers Choice Awards
Theyre back and expanded, the 2004 Readers Choice awards. Take a minute and vote now for the products and vendors you have enjoyed working with.
List of Database Users with Database Roles
SQL Server shows lots of information in Enterprise Manager, but getting a report for someone or manipulating this data is hard from the GUI. Using T-SQL, it's easier, but sometimes not obvious how to get the data. Author Santveer Singh brings us a way to get at some of that information, the users and their database roles.
Blogs
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Forums
The Learning Plan for 2025
Comments posted to this topic are about the item The Learning Plan for 2025
Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
Comments posted to this topic are about the item Leveraging the “STUFF” Function for...