Searching Objects for Text
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,761 reads
Articles
Data Generator Source Adapter
This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated.
2008-05-28
2,077 reads
Implementing Table Interfaces
Last time, we discussed Table inheritance, which allowed us to easily reduce redundancies in our table design by creating "base" or "super" tables that contain columns and relations that "sub-tables" automatically inherit.
2008-05-28
3,163 reads
Job Specialization - Boon or Bane?
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around?
2008-05-28
49 reads
Job Specialization - Boon or Bane?
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around?
2008-05-28
40 reads
Job Specialization - Boon or Bane?
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around?
2008-05-28
36 reads
Database Snapshots
This white paper I will explain how exactly this new feature works, why you may or may not consider using it, and how to get started using it.
2008-05-27
11,457 reads
Uninstall SSRS If you are not using it
Encryption Keys validation for Reporting Services always being in force whether service is running or not.
2008-05-27
9,221 reads
Web Data Adminstrator
Accessing your SQL Server without Enterprise Manager or Management Studio can be a difficult task without a custom application. Especially if you are not in the office. Jacob Sebastian brings us an open source application that can make this much easier for DBAs.
2008-05-27 (first published: 2007-06-27)
7,580 reads
Create a SQL Server Data Dictionary in Seconds using Extended Properties
I need a way to create a data dictionary that will stay up to date. I make many changes to the database and I spend more time trying to keep the documentation updated than doing database administration.
2008-05-27
6,370 reads
Blogs
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...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers