The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
2007-09-18
5,642 reads
In the latest in their popular series on 'Unit Testing' database development work , Alex K and Alex S give some examples of unit testing Database Modifications
2007-09-18
3,422 reads
We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.
2007-09-18
4,268 reads
Everyone wants to know what a DBA does and it is becoming a hard question to answer as the responsibilities and capabilities of database platforms increase. Longtime author Vincent Rainardi brings us the proposition of a new type fo DBA, one that focuses more on data warehousing.
2007-09-17
8,492 reads
There's a free event in Indianapolis for SQL and .NET developers. It's on October 13th and it's jointly sponsored by the .NET and SQL users groups. If you're in the area reigster and support this group.
2007-09-17
588 reads
An article explaining where to find packages when saved to SQL Server.
2007-09-17
3,092 reads
2007-09-14
3,449 reads
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
Take a look at a sample chapter and see who won copies of this book from our Question of the Day Contest.
2007-09-13
2,759 reads
With business intelligence and the Anaylsis Services platform becoming more and more popular, this has to be the hottest development team for SQL Server. Join us with a look at one of the leaders of Analysis Services development, Rob Zare.
2007-09-13
1,686 reads
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
By Kevin3NF
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk...
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers