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 […]
Editorials
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 […]
On Automation and SQL Server
Get Social! Twitter – Facebook SSWUG.ORG page vWorkshop – Just a Couple of Days Away – 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 […]
Would You Trust/Allow Automated Tuning?
Announcing – Next DBASchool – In-Person Class Instructor: Stephen Wynkoop 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 students so we can […]
What Would You Call SQL Server?
Featured Article(s) Useful Undocumented Miscellaneous SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented miscellaneous DBCC commands that shipped with SQL Server 2008. Combine Named Sets and Calculated Members in Analysis Services, Pt. 3 Part 3: Combine Named Sets with Calculated members to meet client and employer business requirements. Join BI Architect Bill Pearson as […]