Best way to learn Powershell is Bruce Payette's book: PowerShell in Action. First edition is just fine, second covers remoting as well.

But Daniel, why do you use "echo $var" to...

Hi,

Reading through the indexes is a smart move! I might steal the idea 🙂

If I may have some improvement suggestions:

1. Instead of index(1), use select * simply, orelse LOB...

The easiest way is to shut down SQL Server, start it up in single user mode (sqlservr -m) and in this state OS admins will get sysadmin privilege, no matter...

Hi,

Are you using the same email address at both locations? That might be a reason (if not).

Small addon: I use logon triggers to use the source address as filtering criteria. To avoid any tampering opportunity, this provides the IP address of the client, no name resolution....

Sysadmins will still see everything. However, you can set up fine-grained audit to collect who read what from the sensitive database, stating that for all of the X persons you'd...

Hi Rohan,

In SSMS (SQL Server Management Studio) connect to the server and find the Replication node. Browse to the object you need then right-click and generate script... Hope this is...

Hi Zee,

Hard task, no doubt 🙂 When I had to do thing like this, I iterated: started from the big chunks to the smaller things. First: databases and logins: who...

Hi,

If you're a programmer guy, you should carve a name into your brain: ITZIK BEN-GAN. Literally anything written by Itzik will make you a professional. Definitely, not the easiest material,...

If I were you, I'd consider putting an index onto that field. If there's no clustered index at all, basicaly you can pick almost any column which would work for...

Hi Shailendra,

In MSSQL, you should format in the query itself. For this, you can use the CAST and/or CONVERT functions. A short example below will show you the difference if...

Hi Nagesh,

Licensing is a legal question. If you have 100 users using the webapp connecting to the SQL Server ,and you use the Server+CAL model, you need 100 CAL. Of...

Hi Peter,

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.yourview'))

will provide you the definition only. I understand you're looking for this. Hope I'm right 🙂

Hi,

Question is the purpose of the SQL 2008 instance. That is, if the hardware is strong enough to run two instances on the same node (and you can provide them...

Hmmm... IMHO if you specify the failover partner in the connection string and your application can reconnect after a failure, this should work. If the principal is active, then it...