I have created several policies using Policy-Based Management and need to rename some of them. I don’t see an option in the GUI to rename a Policy. Is there any way I can rename them without dropping and recreating them?
2010-09-22
2,209 reads
Steve Jones has attended the PASS Summit almost every year, and in that time he's learned a few things. He shares a few today that might convince you or your boss that it's worth funding the trip this year.
2010-09-21 (first published: 2010-05-17)
5,241 reads
The idea is to create a SQLCLR table valued function that returns all information on drives in a UNIX df-like style.
2010-09-21
9,897 reads
The DBA and Virtualization Virtual Chapters hope that last weeks 24 Hours of PASS got you in the mood for more free training. Here's what they have on tap for you this week:
2010-09-21
737 reads
In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight. Here is the solution for that post. The download contains Project that reads events from a previously recorded trace file Project that starts a trace and captures events in real-time from a custom trace definition file (Included) It is a very simple solution and could be extended.
2010-09-21
2,192 reads
In this article, learn about the risks of changing server collation as well as how to go about making this change.
2010-09-20
15,436 reads
This challenge is related to an inventory management application where your job is to calculate the profitability by item (cost v/s sales) using First-In-First-Out (FIFO) processing method.
2010-09-20
2,157 reads
Ever wanted to know how he can identify whether a database uses any of the features that are restricted to a specific edition of SQL Server 2008. In this tip we will go through the steps a DBA needs to follow to identify a database which uses edition specific features.
2010-09-20
3,009 reads
Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pummelling recalcitrant correlated subqueries.
2010-09-17
5,029 reads
When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples.
2010-09-17
6,847 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Comments posted to this topic are about the item Four Rules for Adding AI...
Hello, the title says it all. Is the SQL Server 2025 section missing?
I am not sure which is the best way to proceed. I have parent...
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers