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 Help – How Do You Use the Newsletter?
I have a request. I mentioned this week that, with the launch of the new SSWUG site (more to come on this), we’re also rebuilding the newsletter. I need your help.
If you have a minute or two, would you mind giving some feedback and guidance on how YOU use the newsletter? I would really appreciate it – it’s not a long survey, there are no strings attached and it would directly impact the direction of the newsletter as we roll it out.
I’d really like to have a newsletter that delivers what you need in the way you need it. Questions are centered around how you use the newsletter, what you like, don’t like, etc. It would be really helpful if we could hear from you (yes you!) about your particular thoughts and views.
We’ve come to find out that many people use the newsletter in different ways to keep up with happenings on the site – and we’d like to see if these were "oddities" or a sign of change in how people need to receive information.
Featured White Paper(s)
Real-Time Data Integration for the SQL Server Data Warehouse
The Microsoft SQL Server database is becoming an increasingly popular platform for hosting data warehouse and operational rep… (read more)