(Steve Guendert) Companies using analytics to gain additional business insight often outperform their peers, as is often seen in their financial results. The ability to analyze information at the speed of thought is being viewed as a core competency and a source of competitive differentiation becaus
Other News
The Long and Short of It
(Mark Bowytz) Not just once, but repeated in various lucrative apps — a humongous chunk of code that should’ve been reduced to a mere line.
Oracle: Too Much Time On Your Hands?
(David Fitzjarrell) Automatic Workload Repository (AWR) reports were a tremendous improvement over Statspack reports, primarily due to the depth and breadth of the sample data collected. A more detailed report, with extended metrics, provides a better look at what the database is doing during a give
Reviewing the SQL Server Audit
(Kenneth Fisher) Deciding what method to use to collect audit information can be a task in and of itself. Depending on your needs there are a number of different ways to collect the information.
T-SQL COALESCE Example
(Derek E Wilson) SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression. For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if it exists or the SellStartDate if the SellEndDate is nu
Failing over AlwaysOn Availability Groups
(Derik Hammer) A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over.
SQL – How to Find Missing Sequence in a table
(Prashanth Jayaram) Problem statement: A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Application Architecture Pains
There are way too many layers of separation in this application. A single change takes hours because the change has to be performed in so many places. The application was built using a large number of layers so that they could be replaced with something else at a later time. The problem is that we never have time to replace […]
SSWUGtv: The Precedent of Sony
Video Programming for IT Professionals
General facts of SQL SERVER – part 3
General facts of SQL SERVER – Part 3 Database engine The database engine offers sustenance to stock, enquiry, fabricate plus protect the information on the database server. The database engine is comprises of databases plus database objects for an example tables, store procedures, triggers, view, etc. This database engine permits an individual to produce as well as handle the database...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here