XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
RAID Scaling Charts, Part 3: 4-128 kB Stripes Compared
This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.
Serve SQL Data in XML Format
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Data Ownership
Who owns the data that we generate ourselves? It's not as easy to answer that as you think.
Login creation in SQL Server 2005 for SQL Server Authentication Mode
Its a graphical representation of login creation in SQL Server 2005 for SQL Server Authentication Mode.
Usages of CONTEXT_INFO
How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.
RAID Scaling Charts, Part 2: RAID 5 And RAID 6
For our RAID tests, we once again use Samsung HM321KJ SATA/300 drives. This time, we benchmarked RAID 5 and RAID 6 setups with three to eight hard drives.
Using the DATE data type in SQL Server 2008
In SQL Server 2008 we get a new DATE date type that allows you to store a date without a time.
Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers