Performance Implications of Database Snapshots
Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be.
2008-09-23
9,699 reads
Articles
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
2008-09-23
68 reads
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
2008-09-23
73 reads
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
2008-09-23
76 reads
Intrinsic Member Properties: The MEMBER_VALUE Property
MSAS Architect Bill Pearson leads hands-on exercises providing exposure to the use of the MEMBER_VALUE intrinsic member property. Join us in generating simple lists, as well as datasets to support report parameter picklists.
2008-09-23
2,026 reads
Scheduling Jobs in SQL Server Express
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database reindexing, statistics updating, etc. This is why I wanted to have a solution based only on SQL Server 2005 Express and not dependent on the hosting company. And of course there is one based on our old friend the Service Broker.
2008-09-23
3,241 reads
Blog: Cross Functional Teams & Cross Training
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it.
2008-09-22
2,211 reads
Kalen Delaney: Geek of the Week
Kalen Delaney has been involved in SQL Server from the beginning. Her talks and her writings are always interesting but, most important of all, she was able to successfully take on authorship of the 'Inside SQL Server' series of books from Ron Soukup, and make them her own. Despite her own protests that she is a trainer first and foremost, she richly deserves our accolade of 'Geek of the Week'.
2008-09-22
2,473 reads
Performance tuning through memory and CPU
In this tip, learn how memory allocation and CPU processing impact SQL Server performance and get tips for tuning these areas.
2008-09-22
4,447 reads
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
2008-09-22
61 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers