PASS 2006 Reception
Once again the SQLServerCentral.com staff is putting on a Tuesday night reception. Read how you can attend this November in Seattle.
Reap the Benefits of SQL Server's New Database Tuning Advisor
The Database Tuning Advisor (DTA) is an improvement over the old Index Tuning Wizard. Learn how to access the advanced features of DTA from the command line with a custom configuration.
SSIS Training
SQLServerCentral.com is offering Integration Services training at our new training center. Sign up today and learn from Brian Knight, MVP and SSIS Guru.
Agile Development and ICONIX
Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...
Further Your Career
Training is an important part of anyone's life in technology, especially if you are a SQL Server DBA or developer. With the release of 2005, the entire paradigm of working with SQL Server has changed and you need to be working on your own personal knowledge base. Steve Jones takes a look at how you can get training and shake the funding loose as well.
To SP or not to SP in SQL Server: an argument for stored procedures
A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve the use of stored procedures.
Management Issues - SSAS 2005
For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started.
The May SQL Server Standard
Better late than never, here's a look at the May issue of the SQL Server Standard, now available as a PDF.
Quickly Viewing Available Space
As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of information that have moved and may give you trouble finding. Boris Balinger brings us a followup to his first look at some of those changes with a quick article on how you can get the free space in your database files.
Strategy, Tactics, and Business Intelligence
There is a lot of talk these days about “business intelligence” (BI for short). Pick up any magazine aimed at business or technology professionals, and you’re sure to read about things like data warehouses, dashboards, cubes, ETL, SCD, and a seemingly endless list of other specialized terms and acronyms. One might be left wondering, is this something to which I should be paying attention?
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
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