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,...

If data belonging to the museum was hacked, then that's obviously an issue.

However, regarding the Nefertiti sculpture, I'm not fully understanding the outrage over the reproduction. Is a 3D...

In addition to Crouching Cursors and Hidden Triggers, some other pitfalls that can lead to the demise of a DBA are stored procedures compiled with non-default SET-ings, remote joins, and...

Ask your DBA if she can create a special database for which you are the owner, so you can use it to create your tables and stage data for reporting...