(David Fitzjarrell) Performance is one of the big watchwords in the IT industry; nowhere is it more often used than in the database arena, and it’s usually not a good sign. End users know nothing, really, of the inner workings of the database yet they are the first to point the ‘finger of blame’ at
Other News
Rename or Change SQL Server Standalone Default Instance
(Rohit Garg) Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.
SQL SERVER – Find Blocking Using Blocked Process Threshold
(Pinal Dave) In my previous blog I was talking about my friend Jim who was on a consulting assignment and was asking me for some help around blocking. Though the tip mentioned was of help, Jim did reach out to me the day after and had more queries.
Reliability and Performance with IBM DB2 Analytics Accelerator Version 4.1
(Paolo Bruni and Willie Favero) IBM DB2 Analytics Accelerator V4.1 expands the value of high-performance analytics. DB2 Analytics Accelerator 4.1 opens to static SQL applications and rowset processing, minimizes data movement, reduces latency, and improves availability.
RDP Client for Windows RT
Windows RT is a nice little computer. It is designed specifically to run applications from the Windows Store. It does not have the same architecture of WinTel machines, and therefore cannot run the applications like you run on your desktop or laptop. This doesn’t mean you have a horrible platform as there are thousands of RT enabled applications doing most […]
SSWUGtv Security Edition: Key management vs. key storage with Steve and Patrick Townsend.
Video Programming for IT Professionals
Difference between Session and Cache
(Nagendra kumar) Both session and cache can be used to store the data at the server level (also “Caching” can also be done at client side for static files). Main defference is that Session is created for each user/browser request. It is user specific. and the data stored in session expires when the
Extending jQuery Selectors
(Rich) A small source of frustration for jQuery developers is the :contains() selector doesn’t have a startswith option. A selector indicating elements that start with a string is extremely helpful, but the good folks at jQuery central haven’t given us one.
Cascading delete in SQL Server
(Sheo Narayan) In this article, we shall learn how to enable cascading delete option while creating foreign keys constraints in the SQL Server database.
Foreign Key Constraints: Friend or Frenemy?
(Mickey Stuewe) In the early 1970’s, Edgar F. Codd, a pioneer of the relational model for databases, gave us the rules of normalization to help us design and maintain relational databases.