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

Aggregate downtime per year is a common baseline measurement, but it may not be the right question. In many cases it's really a matter of how much contiguous downtime can...

Thomas Hütter (4/15/2016)

---

Well, concerning downtimes of Azure, here's some recent experience of mine:

I attended 2 SQL events so far this year, at both there were speakers breaking their demos because...

In many organizations, the physical model of the database is entirely determined by the default behaviour of whatever data modeling or ORM tool was used by the developer. It's not...