New Videos Posted:
Watch: SelectViews: Noise and News in the Database World
…from Yesterday:
Watch: SQLonCall: How to Hire a DBA – Reading (really reading) the resume and knowing what to look for, what to *watch out* for.
Watch: SelectViews: Book Looks: SQL Queries for Mere Mortals
Featured Article(s)
Finding the CPU/DISK IO most consuming session procedure
The following procedure accepts parameter C for CPU or D for DISK IO and returns the process SPID that consumes the most of the given parameters resources on the server The procedure uses sp_who2 system SP for the job
More Than Intelligent Editing… a True Boon to Getting Your Work Done
Sure, it helps you with your SQL statements. Yes, it formats your statements, provides templates for statements and even gives you an interactive object-explorer as you type. But, there’s much more. It helps with best practices in your coding by providing you with with pre-formatted statements, let’s you dynamically work through a graphical query builder where you can pick and choose parameters and options. Oh, and it works in SQL Server as well as Oracle, DB2, MySQL.. You need to take a look at this add-in for your own environment. It can be a *huge* boost to getting things done. Get more information here.
Do You Follow "Web 2.0"?
I often have a number of books going, frequently about what different "experts" see happening with Web 2.0, new uses of the technology, etc. I think it’s fascinating to see what they think will happen, what impact existing things like social networks and overall information availability has on every day life, etc. I’ve been reading a lot too about how information (data) will be used and made available in mass to different outside applications. Applications "outside" your traditional walls and applications looking to share, modify, repurpose and reuse information as they need to.
I’m curious if you follow these trends and whether you see this as an issue or something to be thinking through for your own databases? If you look into the development work Microsoft and others are doing to expose data structures, to make functionality available to anonymous users and that type of thing, you can see that slicing up information to make it available to these types of services and utilities will be a major consideration for DBAs and developers alike.
So, do you? Follow it that is. Is this something on your radar that you keep tabs on?
Reminder: Last 2 Days for the Survey
Don’t forget – tomorrow (Friday) is the last day to take part in our survey. Get more information here. (And yes, there are multiple cash prizes to be had just for filling out the survey!)
Featured White Paper(s)
Development, Change management, Code and Project deployment: Processes and Automation in SQL Server Environments
This white paper explores best practices and common approaches to managing the lifecycle of database projects in SQL Server e… (read more)
Profiling SQL Server Performance by Kevin Kline
Database changes impact database performance. The challenge is that DBAs lack the necessary expertise and cannot afford the o… (read more)
SQL Injection: What it is and how to prevent it
SQL injection is the hacking technique which attempts to pass SQL commands through a web application for execution by a backe… (read more)
Troubleshooting and fixing a .NET application that accesses a database
Troubleshooting and fixing a .NET application that accesses a database is a generic problem. It’s also one that Red Gate Soft… (read more)