Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
42 reads
Articles
Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
27 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
34 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
29 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
28 reads
Recursive Queries in SQL Server 2005
Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.
2008-04-18 (first published: 2005-03-03)
94,423 reads
Integrating Reporting Services into Your Application
This paper summarizes the different ways that developers can integrate SQL Server 2005 Reporting Services capabilities in their applications.
2008-04-18
10,171 reads
Set Functions: The StripCalculatedMembers() Functio
Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.
2008-04-18
2,513 reads
High Availability (DR) Using SQL Server 2005 Transactional Replication
One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.
2008-04-17
7,790 reads
Reverse engineering alias data types - Part 5
Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.
2008-04-17
1,194 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers