Author: Stephen Wynkoop

Editorials

Are You Updating Statistics with Your SQL Server?

(Class sessions available tomorrow) SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts May 15 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own shop. There is SO MUCH information packed […]

Editorials

Counters, Troubleshooting, Performance and More

Featured Script Data_Time_Master_Table This Script is step 2 to see the Impact of Forced Parameterization this will populate the data in time master table which was… (read more) (Only ONE days left to register for the class this month) SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts May 15 and you can register now to attend! Brought straight […]

Editorials

Counters… What Do You Watch?

(Only two days left to register for the class this month) SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts May 15 and you can register now to attend! Brought straight to your desktop, this 12-session class includes weekly business hours with Eric, LOTS of information about SSIS and how you can put it to use in your own […]

Editorials

PowerShell, BI, Data and Information

Webcast Tomorrow: SharePoint Infrastructure: The databases, file structure, and services that make up your SharePoint Implementation. In this session, we will discuss the various databases that are created when you install SharePoint from various options. We will also take a deeper look into the 12 hive file structure and the services that are required. Presented by: Shannon Bray > Register […]

Editorials

Making the Most of Your Data – Your Experiences?

SelectViews Show Available Now Kalen Delaney on the show today talking about her work with SQL Server, upcoming workshops and other thoughts. Also on the show, SQL Server 2008 R2, Mary Leigh Mackey from AvePoint and much more. [Watch the Show] Featured Script GetTbColValues Find table column names… (read more) SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts […]

Editorials

Kalen Delaney on SelectViews Show Today

Featured Script Audit – Database Details Several queries to show tables, columns, PK, FK, Unique keys and indices… (read more) New SelectViews Show Released Kalen Delaney on the show today talking about her work with SQL Server, upcoming workshops and other thoughts. Also on the show, SQL Server 2008 R2, Mary Leigh Mackey from AvePoint and much more. [Watch the […]

Editorials

How do you know if you need a full-time DBA?

How do you know if you need a full-time DBA? Real-world experiences from Bev – and how THEY knew it was time – "We are about 2 years into our SharePoint implementation. We are a school board and the plan here is to use the sharepoint environment for all collaboration and document storage etc. for all administrative, teaching, student and […]

Editorials

Does SharePoint Change Your Approach?

SQL Server Security – Only about a day left to register! Our SQL Server Security virtual workshop is happening Friday – so you only have a day or so to get registered and save your spot! I’ll be teaching the workshop and we’ll be covering the different aspects of SQL Server security, including injection and what you need to be […]