(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 […]
Cross Database Dependency
Featured Article(s) Molecular MDX: Change Across Periods and Periods-to-Date Aggregations, Part 1 Part 1: Understand the basics of comparing periods, and accomplish year-to-date and other time-based aggregations, across the Time dimension. Join author Bill Pearson in a practical introduction to the mechanics of time and the analysis of change from period to period, as well as period-to-date aggregation at multiple […]
Smaller Procedures are Better Your Responses
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] SSIS Class – Online, 12 Hours/classes Eric Johnson’s class starts May 15 and you can register now to attend! […]
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 […]
When Writing Stored Procedures – Smaller is Better
Webcast Today The Balance of Powers, Understanding SharePoint Governance: Is it an application? Is it a website? Is it a functional tool? No, look it up on the internet, it’s SharePoint! With most technologies users are provided with a "how to" manual and understand that complaints go to the IT department. Online collaboration powered by SharePoint doesn’t follow the same […]
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 […]
Full-Time SharePoint DBA/Admin Needed – Reader Feedback
Webcast: The Balance of Powers, Understanding SharePoint Governance: Is it an application? Is it a website? Is it a functional tool? No, look it up on the internet, it’s SharePoint! With most technologies users are provided with a "how to" manual and understand that complaints go to the IT department. Online collaboration powered by SharePoint doesn’t follow the same form […]
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 […]
A Full-Time SharePoint or SQL Server DBA Required?
Last Day to Register for tomorrow’s SQL Server Security Virtual Workshop [Register Here] or [Get the course outline] Featured Script Audit – Which tables have Primary Keys List of every table and if it has a Primary Key or not… (read more) A Full-Time SharePoint or SQL Server DBA Required? I had a great question posed by a reader yesterday. […]