2008-06-25
45 reads
Articles
2008-06-25
20 reads
2008-06-25
42 reads
Exporting and Versioning Lookup Data: A Real-World Use of the CLR
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,689 reads
Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.
2008-06-24
1,399 reads
SQL Server Disasters with Preventive Measures
Have you seen disasters in your environment? I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.
2008-06-24
3,790 reads
T-SQL Data Processing
This article from new author Peter Kierstead shows us how to implement your own "fuzzy" dedup/merge logic without resorting to RBAR in T-SQL.
2008-06-23
8,016 reads
Execute SQL statements in Integration Services
This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary.
2008-06-23
4,026 reads
Transparent Data Encryption in SQL Server 2008
This article describes how the Transparent Data Encryption feature in SQL Server 2008 can be used to secure your databases
2008-06-23
2,364 reads
Best Practices for Database Design
One of the few things that SQL Server does not automatically help you with is the design of your tales, views, and other database objects. Having standards and design techniques can greatly ease the maintenance of your schema as well as ease the transition to having others work with the database. New author J.D. Gonzalez brings us some of his naming techniques to keep things organized.
2008-06-20 (first published: 2005-04-06)
52,306 reads
Blogs
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Forums
Troubleshooting WQL in custom PBM conditions?
Hi, I'm currently trying to implement policy based mgmt with a condition to query...
Analysis of Locking Issues on Secondary Replicas in AlwaysOn Availability Groups
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers