Blog: SQL Server 2008 Transparent Data Encryption
A great summary from MVP Brad McGehee on the new TDE feature in SQL Server 2008
2008-10-06
3,124 reads
Additional Articles
SqlCredit – Part 19: Exploring SQL 2005’s Ranking Functions – RANK() and DENSE_RANK()
Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.
2008-10-06
3,629 reads
Data Access Tracing
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.
2008-10-03
2,854 reads
MS Access Can Handle Millisecond Time Values--Really
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.
2008-10-03
2,319 reads
Configure Windows Firewall for SQL Server Remote Connections
This article describes the process of how to configure the Windows firewall for SQL Server
2008-10-02
2,670 reads
The Many Benefits of Money…Data Type!
Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).
2008-10-02
2,761 reads
Blog: How to Script a Profiler Trace as a SQL Trace Data Collection Set
MVP Brad McGehee shows how you can use Trace data as a source for your data collections for the new Management Data Warehouse
2008-10-01
2,900 reads
How To Use Transactions in a SQL Server Integration Services (SSIS) Package
I am trying to build an SSIS package where the entire package is encapsulated in a transaction. In addition there is a table that needs to remain locked for the duration of the SSIS package execution. Can you provide an example of how to do this?
2008-10-01
4,495 reads
Navigationless Database XML: Hierarchical Data Processing
Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.
2008-10-01
3,542 reads
Resource Governor in SQL Server 2008
This article describes how Database Administrators can manage SQL Server workload and critical system resource consumption using Resource Governor in SQL Server 2008
2008-09-30
2,126 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers