High Availability Lingo
You have got to love the way the SQL Server team change the lingo in all of their high availability...
2012-08-13
1,154 reads
SQL Audit 301 – Using Powershell to Manage Audits
Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...
2012-08-20 (first published: 2012-08-13)
3,234 reads
Schedule Announced for SQLSaturday #151 in Orlando
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
353 reads
Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,717 reads
Bloggers–Don’t Make It Hard to Comment
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
381 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,765 reads
Find AD user detail - PowerShell Script
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,926 reads
Find Members of AD Group - PowerShell Script
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,167 reads
Monitor Deadlock in SQL 2012
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,097 reads
How to list all CLR objects inside your database?
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,323 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers