But out of the box SQL Server's default settings are tight as far as security is concerned. We don't really need to nail things down so much as avoid bad...

Brent Ozar's popular sp_Blitz is mainly geared toward server configuration and physical modeling best practices, but it also contains some checks for security best practices as well; checking for things...

Also, confirm if there are any login triggers.

Phil Parkin (4/21/2016)

---

j-1064772 (4/21/2016)

---

Having said that, C# includes very efficient dictionary structures that can be used to process data way faster than the SQL Server can, if the network can...

tyranicide

singhamitpal (4/19/2016)

---

I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

1.Very few developers will be able to create a consistent stored...

singhamitpal (4/19/2016)

---

Thanks for the response...

I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really...

The entire ETL process can be done using SSIS. For OLAP cubes, SSAS, and for reporting and dashboards, SSRS.

I'd reccomend this book, which coveres everything you described end to...

Can anyone vouch for the usefullness of this Sandboxie thing as a solution for isolating web browsing?

Sandboxie uses isolation technology to separate programs from your underlying operating system preventing unwanted...

Rather than containing your user defined attributes within a straight XML typed or VarChar column, instead consider defining a Column Set, which is essentially a relational column-ish abstraction layer for...

But the most important thing to keep in mind about ransomware, and this is a popular misconception, is that the most common attack vector is a trojan program that you...

As for how to prevent ransomeware attacks, the following blog post describes a method of thwarting Crypto (the same trojan that attacked my PC) by disabling the Microsoft API encryption...

How can avoid such locking / dead lock issue.

...

...

eg. session 1 is updating data as below:-

BEGIN TRANSACTION

UPDATE CustomFields SET Location = 'Mumbai' WHERE Id = 100

session 2 is...

Is it possibly procedure recompilation that causing high CPU ultilization?

First, confirm that SQL Server is recognizing all the memory and CPU cores you'd expect. Also, from what you see, is it a systemic high CPU utilization across the board,...