Featured Article(s) Writing efficient Stored Procedures – A Case Study (By G.R. Preethiviraj Kulasingham) Performance optimization of Stored Procedures for developers. This article is a case study, which re-writes a stored procedure in different ways in order to optimize the performance. New Video: SelectViews SQL Server Show Today’s show – we’re looking at the automated SQL Server Injection that’s going […]
Editorials
Stolen Data Homing Devices… Sort Of.
Final Thoughts on Data Shoplifting Karen: "First–let me start by saying that most contractors I propose are like myself, honest to a fault and extremely careful to not do anything that would even appear to be dishonest or cause any problem at the workplace. We respect and admire the people with whom we work and generally work harder and longer […]
Trust, but Verify That Keeper of the SQL Server Keys
30 Sessions, 11 Speakers, ALL SQL Server No Travel, No Hotel, Just technical content. Direct to your computer. The SSWUG.ORG Virtual SQL Server Conference Featured Article(s) Troubleshooting SQL Server 2005 jobs (Part 1) In this article, Alexander Chigrik explains some problems you can have with SQL Server 2005 jobs. He also tells how you can resolve these problems. Two Keys, […]
Two Keys, an Encrypted GO Word…
Video: SelectViews #105: Login Audits, Accidental DBA Quick Performance Checks, SQL Injection and Upcoming Events. Also, Find Out About Noise and News in the DB World and the 60-Second SQL Server Tip of the Day. > Watch The Show Other Video Programs/Shows available: [Watch] SQLonCall – Staying on Top as a DBA [Watch] SelectViews – Accidental DBAs, 60-second tip of […]
Reader Feedback on Data Shoplifting
Featured Article(s) Oracle 2-Day DBA in x Days Post 6; Understanding Oracle’s Networking Environment Getting to understand Oracle’s network configuration files is essential to understanding how client applications connect to the database. Plus a few extras. SSWUG.ORG SQL Server Virtual Conference We’re bringing more than 30 sessions, 11 speakers and a WHOLE lot of content direct to your computer. Travel […]
SQL Injection – New Approaches, New SQL Server Show Posted
New SQL Server Show Posted SelectViews #105: Login Audits, Accidental DBA Quick Performance Checks, SQL Injection and Upcoming Events. Also, Find Out About Noise and News in the DB World and the 60-Second SQL Server Tip of the Day. > Watch The Show Featured Article(s) New Data Source Controls in ASP.NET ASP.NET 2.0 and beyond comes in with a bundle […]
Database Shoplifting
How Do You Do It? I’m starting to see more and more blogging, articles and other mentions about an emerging issue with databases. That issue is what I refer to as "shoplifting" of sorts – data theft from within. There have been recent reports of employees or other privileged folks (contractors, for example) either putting software in place to gain […]
Motivation to Learn as a SQL Server DBA
New Show: SQLonCall – Staying on Top as a DBA Continuing Education for DBAs. How do you know where to spend time and resources? What types of things can you do to help out the DBA team as they need to stay on top of technologies? > Watch Show Other Video Programs/Shows available: [Watch] SelectViews – Accidental DBAs, 60-second tip […]
Reader Feedback – Your SQL Server Matrix
SQL Server Toolset – Free Beta (and possibly win a WII) – Have you seen the new Idera Toolset? It’s nothing short of an incredible assortment of tools for your SQL Server. There are *24* different tools in this set and you can test it out – from diagnostic tools to security checks to change management and much more. Take […]
A Huge Thank You
A Huge Thank You! Our survey was a huge success due in no small part to our sponsors who donated some amazing prizes. If you’re looking for some killer tools and applications that can truly make your life easier, take a look at these applications – they are great software and our prize winners were really jazzed about winning – […]