New Videos Posted: Watch: Food for Thought: Direct SQL Good Idea/Bad Idea? What is it?!? Find out why you should avoid direct SQL. Watch: Upcoming Events in the Database World Watch: Full SelectViews Show with these and other segments Featured Article(s) Understanding Windows Share Point Services A human being’s need for communication is as strong, instinct and as basic as […]
Author: Ben Taylor
Data Warehousing Implementations from Readers
Featured Article(s) All Databases In Server: Simple Status Check The following T-SQL function returns a small int number for the count of all databases that either not ONLINE or that do NOT have READ-WRITE updatability or that the User access are not multi-user meaning all databases that have some restriction on them. Video Posted: Discussion List Watch Oracle to SQL […]
Data Warehousing Implementations from Readers
Featured Article(s) All Databases In Server: Simple Status Check The following T-SQL function returns a small int number for the count of all databases that either not ONLINE or that do NOT have READ-WRITE updatability or that the User access are not multi-user meaning all databases that have some restriction on them. Video Posted: Discussion List Watch Oracle to SQL […]
New SQL Server Show Live Now
New SelectViews Show Posted (and a new format!) We’re experimenting with releasing the show in segments, so you’ll be able to watch different portions of the show at different times during the week (we’ll be releasing a segment every day now). OR, you can tune in on Fridays (starts next week) to watch the entire program all at once automagically. […]
New SQL Server Show Live Now
New SelectViews Show Posted (and a new format!) We’re experimenting with releasing the show in segments, so you’ll be able to watch different portions of the show at different times during the week (we’ll be releasing a segment every day now). OR, you can tune in on Fridays (starts next week) to watch the entire program all at once automagically. […]
Building Out a BI Infrastructure
Featured Article(s) Is it Time to Terminate an Employee A few years ago I had to make an incredibly hard decision on whether I let an employee go or if I tried to keep that person on my team and develop that persons skill set. Far too often people determine a DBAs skill set by only factoring in how much […]
Building Out a BI Infrastructure
Featured Article(s) Is it Time to Terminate an Employee A few years ago I had to make an incredibly hard decision on whether I let an employee go or if I tried to keep that person on my team and develop that persons skill set. Far too often people determine a DBAs skill set by only factoring in how much […]
Business Intelligence – What’s Your Approach?
New SQLonCall Show Posted! Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here. > …and, you can catch the most recent SelectViews SQL Server Show here […]
Business Intelligence – What’s Your Approach?
New SQLonCall Show Posted! Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here. > …and, you can catch the most recent SelectViews SQL Server Show here […]
Don’t Forget: Sometimes It’s The Easy Stuff…
Don’t Miss the Latest SQLonCall: Basic Security Best Practices (new show posts tomorrow!) SelectViews: Software as a Service, Data Archive Challenge and more Featured Article(s) Diagnosing Poor Data Access Code Using SQL Profiler I created this article to assist DBAs and application developers who need to optimize data access code in their applications. This document covers a few cases where […]