Featured Article(s) Undocumented SQL Server 2008 extended stored procedures to work with files and directories In this article, Alexander Chigrik describes some useful undocumented SQL Server 2008 extended stored procedures to work with files and directories. Work Tamer – One Day IT Pro Events, No Fluff Three lucky Canadian cities (Vancouver, Toronto and Montreal) will be the sites for these […]
Author: Stephen Wynkoop
Access and SQL Server – Tips for Optimization
Featured Article(s) Tips and tricks on improving SharePoint search in larger organizations MOSS 2007 search is not just about single page result set coming from the same MOSS 2007 site; there are many hidden values in this piece of functionality available out of the box. Check out what you have been missing out on in MOSS 2007 search. Webcast TOMORROW […]
Instances vs. Virtualization…Your choice?
New Virtual Workshop Announcement Tomorrow SQL Server Security – Registration will open tomorrow for the December 10 virtual workshop, the next in our series. Featured Article(s) Transparent Data Encryption in SQL Server Security is the first concern a developer face when the decision to create a database or project is taken. Encryption is one of the methods with the best […]
On Using Access with SQL Server
DBASchool – In-Person Class – Hope To See You There! Instructor: Stephen Wynkoop (me!) I’ll be teaching a 3-day class on the things that you really need to know about SQL Server. We’ll have hands-on exercises, lots of discussions and real-world lessons learned. Check out the site here and reserve your spot – we will not allow more than 15 […]
TempDB Lessons Learned – Don’t Miss This Post
Featured Article(s) Edit SharePoint Display/New and Edit form look, feel, and functionality Here is a scenario: you have a SharePoint list (calendar, announcements etc) and your users have requested special changes on out of the box display, new, or edit forms. Whether it`s few extra webparts added, or make another form that will serve a purpose of print friendly version, […]
Using Access with SQL Server?
Featured Article(s) SQL VS ORACLE: A Comparative Review-Part II In part I of the series we examined the general differences between Oralce and SQL. In this Part we shall go a little deeper and examine the differences in the way data is handled in these applications. Index Creation Automation It seems that most agree that outright automation, with tweaks and […]
About Denormalization of Your SQL Server Databases
Announcing: DBA School – Learning SQL Server for the Rest of Us A three-day course taught by Stephen Wynkoop – centered around real-world experiences, how-to information and specific demonstrations and labs that will let you use and explore the topics covered. We’ll be covering Performance, Management, Security, Disaster Recovery more. Find out more at the class site here. The catch? […]
Data Warehouses and De-Normalization
Featured Article(s) How to EASILY Migrate from IIS 6 to IIS 7 There are tons of great new features in IIS7 and the list continues to grow. We identify the top reasons people refuse to upgrade to IIS 7 and show you how a new tool from Microsoft, the Web Deployment Tool, makes the process nearly seamless. It is easier […]
Microsoft “Dallas” Platform – Things That Make You Think…
Featured Article(s) Undocumented Validation SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented validation DBCC commands that shipped with SQL Server 2008. Last Day To Register! Workshop is TOMORROW Tomorrow is the day – 3+ hours of SQL Server performance management and tuning – from understanding indexes, fragmentation and management to the native tools provided […]
SQL Injection Point of Interest
Twitter – Facebook SSWUG.ORG page vWorkshop – Last Days to Register – Register Now! SQL Server Performance – Presented by Stephen Wynkoop I’ll be doing a virtual workshop THURSDAY – several hours on SQL Server performance. Find out about indexes, TSQL tips, monitoring and more. Check out the site for a more detailed outline – you can even get a […]