Physical File Defragmentation
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
2009-05-01
532 reads
Editorials
Mistakes in April
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
2009-04-30
117 reads
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
2009-04-29
101 reads
The Best High Availability
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
2009-04-28
703 reads
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-27
94 reads
Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
2009-04-27
92 reads
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-22
412 reads
Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-21
97 reads
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-20
76 reads
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
2009-04-17
225 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...