OPENROWSET function in SQL Server 2005
mong other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.
Microsoft Reporting Services 2005 Features and Enhancements
Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.
Transact-SQL in 2005
The March issue of the SQL Server Standard is now available for purchase, download, and should arrive in your mailbox any day. Check out the Table of Contents and read the editorial.
SQL Server Redundancy for SMBs
Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.
The Dodgy GO Statement
Do you really understand what happens when you create a stored procedure? What if you have some extra code in your batch? This is an interesting article that shows an interesting effect of creating a stored procedure and where your GO statement is placed.
Microsoft Certification Second Shot Exam Offer Details
Now, you can get a free second shot at any Microsoft Learning IT Professional, Developer, or Microsoft Dynamics (formerly Microsoft Business Solutions) exam.
DTS and Global Variables
SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.
Boost Performance and Reduce Code Use With SQL Server Aggregate Functi
This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish.
Using the Distributed System Designers to Visually Design and Validate
he purpose this lab is to illustrate the benefits of the Distributed System Designers available in Whidbey to application architects, operations teams, and developers. These designers help application architects and developers construct service-oriented applications and prepare them for deployment in a target datacenter modeled by operations.
Using OpenXML Part II
XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers