Is a data warehouse required for business intelligence? Are these synonyms for the same concept? Vincent Rainardi brings us the next part of his data warehousing series that examines these two concepts and how they fit into your data analysis infratructure.
2006-05-23
14,161 reads
In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.
2006-05-23
3,059 reads
With the release of SQL Server 2005, it is more of challenger to Oracle than ever before. Guru Haidong Ji takes a quick look at how these two products compare and gives a few words of wisdom for the next version of SQL Server.
2006-05-22
10,601 reads
2006-05-22
2,852 reads
My CIO and I have looked at a number of commercial solutions for documenting Sarbanes-Oxley compliance. However, we decided to use SQL Server 2005's built-in tools to create our own "home-grown" auditing system.
2006-05-19
3,877 reads
Disaster recovery solutions is always a concern with SQL Server and when a new or unique solution comes up, we like to get it out there. New author Kevin Parks brings us a look at his way of using a USB hard drive and Windows PE to ensure recovery.
2006-05-18
8,738 reads
XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.
2006-05-18
3,096 reads
For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.
2006-05-17
9,053 reads
Data Transformation Services morphed a bit in SQL Server 2000 but nothing compared to what SQL Server Integration Services is today. When I found out Professional SQL Server 2005 Integration Services was coming out, I decided to put it on my list of books to have.
2006-05-17
2,125 reads
Analysis Services 2005 seems like it receives much less notice than most of the other features in the latest version of SQL Server. However it is becoming more widely used in more and more companies. One of the features that can prove useful is the logging of queries. New author Yaniv Mor brings us a look at how this has changed in 2005.
2006-05-16
8,649 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP AM Sangaji Hub.0813•7887•595.Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir,...
Whatsapp:08218171955 Komp, Jl. Taman Ratu Raya Bl. Bl No.5/8, Duri Kepa, Kec. Kb. Jeruk,...
Whatsapp 083831618865 Jl. Batununggal Indah Raya No.149, Batununggal, Kec. Bandung Kidul, Kota Bandung, Jawa...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers