(Thomas LaRock) I found a diagram recently that helped to explain the different types of JOIN syntax. Being the type person that enjoys the visualization of abstract concepts such as set theory this diagram spoke to me. Despite the diagram being well done something seemed slightly wrong about it
Other News
Mouse vs. Keyboard – Determining Click Initiator Using A jQuery Custom Event
(Ben Nadel) When filling out online forms, I love to use my keyword as a means to both provide information as well as to navigate from form field to form field. This works great; but from time to time, an "itchy Tab finger" causes me to accidentally hit "Enter" on an inappropriate form element (such
A few hacks to simulate mysqldump –ignore-database
(Giuseppe Maxia) A few days ago, Ronald Bradford asked for a mysqldump –ignore-database option.
IBM Cognos Proven Practices: Use Case: Diagnosing an IBM Cognos TM1 Server Problem With the IBM Cognos TM1 Diagnostic Tool
A scenario where the user tries to log on to a TM1 server, enters thier username and password, and receives an error message.
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
(K. Brian Kelley) I’ve been tasked with securing my SQL Servers and I need to write scripts to audit them periodically to ensure they are all right. Recently I learned that I need to audit for CONTROL SERVER rights on any SQL Servers I have that are 2005 or above. In this tip we cover what CONTROL S
Should You Use CLR Capabilities?
Should You Use CLR Capabilities? My particular question about CLR capabilities is that I have enjoyed using them for years. Now, considering the utilization of Azure I find they are not available. The reason, you don’t have direct access to disk subsystems in the Azure world, and CLR assemblies require a path in order to work. Sounds like a broken […]
How do you clean data? Do you clean data? Do you clean it after it has been brought into your systems?
Pro-Center Video Programming for IT Professionals
What?s the Fastest Disk?
SSWUGtv With Stephen Wynkoop Don’t miss this episode of SSWUGtv where Stephen interviews Josef Richberg, talking about SSIS. Joseph covers common mistakes, things to know and tips – all for SSIS and SQL Server. Watch the Show Scheduling Tools for Windows Chron Jobs Richard writes: We’ve been using SQL Sentry for five years (or more). It’s one of the best […]
7 Tricks to Attending a Conference on Someone Else’s Dime
7 Tricks to Attending a Conference on Someone Else’s Dime Professional Development Series by Laura Lee Rose Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. As a success and business coach, I encourage continuous...
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
SQLTXPLAIN (SQLT) 11.4.4.5 is now available
(Carlos Sierra) If you have a poorly-performing SQL statement on a read-only standby Data Guard database, now you can analyze it with SQLT. Just need to install SQLT on Primary, create a database link into the read-only and use new method SQLT XTRSBY passing SQL_ID and db link name.