Featured Article(s) MySQL Basic SQL Part V – Counting with SQL Many counting problems I see in answering reporting questions centers around the ability to sum, count, group, and select rows. Most SQL practitioners can count or sum values just fine but when they must answer questions on how the counting or summing relates to other information they don’t quite […]

Featured Article(s) Tips for designing SQL Server 2005 tables (Part 2) Here you can find some useful tips to design SQL Server 2005 tables. Big News from Microsoft on SQL Server Data Services… Microsoft’s SQL Server team today started talking publicly about concrete directions for the cloud-based services that will be offered for SQL Server solutions. Essentially, the net-net of […]

Featured Article(s) Your Next Interview With the economy the way that it is today, I can understand why there are so many articles that are appearing with what to do and what not to do at an interview. Some of these suggestions are just ridiculous. I have hired a number of DBAs and I thought I would add my two […]

Featured Article(s) SharePoint Lists reinvented: data management and reporting If you’re familiar with tools like SQL Reporting Services, Crystal Reports etc you or your end users are probably already taking advantage manipulating your data and exporting it into document-like files of various formats. These days when in typical organization SharePoint took over many roles with variety of templates available out […]

Featured Article(s) Another way of moving user Databases – sp_Detach and _Attach The following stored procedure moves a user databases (mdf+ldf) to another place in the file system not by BACKUP and RESTORE … with move statements. It takes the database offline and moves/copies the files to the new location and then does Detach and attach, uses xp_cmdshell. Request for […]

Featured Article(s) Service Oriented Architecture, Service Oriented Database Architecture and MS-SQL Server 2005 This explains the fundamentals of Service Oriented architecture, Service oriented database architecture and how database SQL server 2005 integrates the concepts New SSWUG.ORG Site Feedback Just a quick note of thanks for all of the great feedback and comments on the new SSWUG.ORG. I really appreciate hearing […]

Important SSWUG.ORG Site News – please see below. I Love This Term for BI I was reading about GoldenGate – they are a data warehousing app – they talk about your information and data systems need to support "operational users and influence what should happen next." What a great overall summary of what BI is all about. I think if […]

Featured Article(s) I Caused a Security Breach…? The President called me into his office not a month later and let me know that the CFO was no longer with the company. I was to shut down all his accounts and make sure that we recovered his laptop. Troubleshooting Disk Performance… The disk system is a common source of performance issues […]

Featured Article(s) Exporting your SQL Server 2005 Backup to an FTP location Now that we have access to tools like SQL Server 2005/8, you might ask "Why would I need such rudimentary form of backup as FTP?". However, in many scenarios, mostly small scale environments where a company would like to take advantage of their FTP server and backup their […]

New SQL Server Show SelectViews: Today on the show we have three interviews – Kevin Kline, Scott Golightly and Anthony D’Angelo. We talked about all sorts of things, from Business Intelligence tricks to upcoming tools. [Watch the Show] Featured Article(s) Simple string encryption without using keys in SQL Server 2008 The following 2 rather simple functions demonstrate the power of […]