Short post this evening… Just in case anyone else flails around looking for this feature, its right under your nose. When you use the PowerShell
I'm still getting used to the new sparse column feature in SQL Server 2008. I'd just read in the BOL definition of ALTER TABLE that
This is the last part of a series on programming policy-based management. The series starts here. In the previous installment, I created a policy that
This post is part of a series on programming policy-based management. The series begins here. So, we were working with a policy that required an
This is part of a series on programming policy-based management. The series starts here. Now, we'll tackle programming a little bit more complicated policy. The
This is part three of a series on programming policy-based management. The series starts here. So, to initialize my Condition's ExpressionNode I need more than
This is the second part in a series about programming policy-based management. The series starts here. To build our MailOffByDefault policy we need: Condition
I've been looking at the new Policy-Based Management (was: Declarative Management Framework) in SQL Server BOL. All of the BOL examples use the SSMS user-interface
This is the last post in the series, at least for now. I'll update it (or post more on the topics discussed here) as the
This post is part of a series about worries when implementing LINQ to SQL or ADO.NET Entity Framework from a SQL database-centric programmer's perspective. The
This post covers LINQ to SQL and EF worry #4. That is: LINQ to SQL and EF will write code that gets too much or
SQL Server 2005 introduced some new features that left “traditional” SQL folks puzzled. What’s the hidden use for SQLCLR? Or the XML data type? Or
This post is part of a series, see parts 1 and 2. Sorry to be so long getting back to this series. This post covers
Recently I had the occasion to load .NET 3.5 on to a machine that had an existing instance of SQL Server 2005. .NET 3.5 does
It’s good to see Ed Katibah open up a blog on SQL Server spatial data. Ed is sort of the “dad” of spatial data in SQL
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.