New Data Types in SQL Server 2008 Part 3
This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.
2008-02-22
3,730 reads
Additional Articles
Storing Images and BLOB files in SQL Server Part 2
Part two of this article focuses on using the SQL Server Binary data type to store small image files.
2008-02-21
3,478 reads
The Stewardship Approach to Data Governance: Ch. 6
This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.
2008-02-21
1,328 reads
New Data Types in SQL Server 2008 Part 2
In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.
2008-02-20
4,301 reads
Add Custom XML Documentation Capability To Your SQL Code
By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.
2008-02-20
2,980 reads
Getting Started with Database Mirroring
If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 with SP1, however, the database mirroring feature can prevent disaster.
2008-02-19
3,726 reads
Integrating Profiler and PerfMon Log Files
In this article I'll show how to create a PerfMon counters log file and SQL Profiler Trace file, how to read them both and how to correlate the two files in SQL Profiler.
2008-02-19
2,933 reads
SQL Server 2008 New DATETIME DataTypes
This article is going to cover the newly introduced data types in SQL Server 2008 July CTP, and will specifically discuss the DATETIME functions.
2008-02-18
4,431 reads
SQL Q&A: Non-Clustered Indexes and Retaining Permissions
Q What are non-clustered indexes, and what are the pros and cons of using them?
2008-02-18
2,161 reads
Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter
This white paper explains how to use SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter to design and deliver full fidelity, data-driven Microsoft Excel and Word reports.
2008-02-15
3,078 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers