With the release of SQL Server 2005, there have been many changes in the product, but probably none as dramatic as the changes to the ETL tool. Data Transformation Services has become SQL Server Integration Services, or SSIS. It has been completely redesigned with a whole new paradigm for developing data movements. Kathi Kellenberger brings us a short introduction to this new tool.
This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.
In this installment of Wicked Code, Jeff Prosise updates his original ASP.NET 2.0 SqlSiteMapProvider to add support for automatic reloading of the site map following a change to the site map database.
It has been nearly 5 years since SQL Server 2000 was released and almost seven since Query Analyzer was introduced in SQL Server 7. Surely every trick, tip, technique, or secret has been published by now? Perhaps, but this might be a new one from Yakov Shlafman. Check out what he thinks is the best kept secret.
Now that the novelty of the Xbox 360, the Razr cell phone, and King Kong have likely run their course, Red Gate Software presents a truly functional gift for the harried IT professional: A handy excuse generator for those projects that just don't work out as planned.
If you live in Florida, join our SQLServerCentral.com's Brian Knight for a Jacksonville SQL Server launch. This free event for developers and DBAs has loads of excellent content from Microsoft and area consultants.
These are not the DMO bits you are thinking of from SQL Server 2000. SQL Server 2005 introduces a new way of digging into the inner workings of the server with both Dynamic Management Views and Dynamic Management Functions. Longtime SQL Server guru Christoffer Hedgate looks at these new ways of understanding your server.
Trying to find the proverbial needle in the haystack of your SQL Server transactions is no small task. SQL Server Profiler not only helps you find that needle, it gives you details on all the other needles in a single interface.
The aggregate functions in SQL Server (min, max, sum, count, average, etc.) are great tools for reporting and business analysis. But sometimes, you need to tweak them just a little bit to get exactly the results you need. For example, if your manager came to you and asked for a report on how many sales have been made to your clients and how large they were, would you know how to get the data you need efficiently? Mark ran into something like this recently and here's the approach he took to solve the problem.
Haindong Ji brings us part 3 of his series on Oracle and SQL Server interoperability, this time taking a look at the Oracle Instant Client.
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Comments posted to this topic are about the item A Challenge of Our Knowledge
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Comments posted to this topic are about the item Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers