2007-09-14
3,449 reads
Additional Articles
String Functions: The .Properties Function
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
2007-09-14
2,842 reads
Reduce Aggravating Aggregation: Improve the Performance of History or
Optimize the performance of a database which includes history or status tables.
2007-09-13
2,625 reads
SQL Server 2005 Express vs. Desktop Engine (MSDE)
SQL Server 2005 Express Edition and the SQL Server Desktop Engine (MSDE) are both free and redistributable. Each product provides a medium where database administrators can work between MS Access and the full version of SQL Server. But there are key differences to consider.
2007-09-13
3,862 reads
Why Data Models Do Not Work: The Role of Reference Data
There is an urgent need to acknowledge the limitations of data models and find a way to bridge the logical-physical divide between models and actual databases so that database designs can be fully understood.
2007-09-13
3,221 reads
How to troubleshoot Service Broker problems
In this one I'll discuss some of the problems that can arise and how to troubleshoot them.
2007-09-12
2,853 reads
Script Task Breakpoints in SQL Server 2008
One of the things coming from our look at SQL Server 2008 Integration Services is that you are not going to see a lot of change visually. What you are going to see is things going on underneath the covers that makes SSIS perform better, and improved informational messages from the components. Just such a change is seen in the Script task.
2007-09-12
2,072 reads
Making the Most of Operational Analytics with Enterprise Decision Mana
EDM solutions are a logical and often necessary complement to operational analytics.
2007-09-11
1,296 reads
Setting Up Delegation for Linked Servers
Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.
2007-09-11
2,732 reads
ASP.NET 2.0: Retrieving XML Data with XmlDataSource Control
This article shows how to retrieve both remote and local XML data and display it in a data Web control.
2007-09-10
4,105 reads
Blogs
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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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