2009-01-27
3,152 reads
Policy Based Management (PBM)
2009-01-20
2,549 reads
Policy-based Management in SQL Server 2008 – Part II
Learn how to use SQL Server Agent alerts and jobs to fix policy incompliance automatically.
2008-05-26
1,726 reads
Using Policy-Based Management in SQL Server 2008
As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?
2008-05-16
2,942 reads
Blogs
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
The Mysterious Empty Table
By alevyinroc
It seems like no matter how long you work with a system beyond a...
Forums
how do you manage new columns in a tabular table
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Why I get null instead I should get 0
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
bypass a non existing server
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers