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 […]

Featured Article(s) Using Flash and Javascript to resolve SharePoint dynamic menus issue If you have ever tried to make your SharePoint or non-SharePoint implementation of the site a little more dynamic you were probably thinking about rotating images or banners. And if you considered implementing them – you will know that because of the crossbrowser incompatibility JavaScript is not the […]

Webcast Today! Get started here: Learn about managing your SQL Server data recovery vulnerabilities In this session we’ll look into the different options you have available to protect your SQL Server investment. Learn about backup and restore, log shipping, replication and other tools you can use to help reduce risk. Find out what is involved, the pros and cons and […]

Only a day left to register… Webcast: Learn about managing your SQL Server data recovery vulnerabilities In this session we’ll look into the different options you have available to protect your SQL Server investment. Learn about backup and restore, log shipping, replication and other tools you can use to help reduce risk. Find out what is involved, the pros and […]