SQL Server Reporting Services
Not yet in beta, MS is working on an add on product similar to Notification Services.
Murach's VB.NET Database Programming with ADO.NET
If you're a VB.NET programmer who wants to learn database programming with ADO.NET, here's a new book that presents all the skills you need in a logical progression from the simple to the complex. Along the way, you'll learn how to use the classes, properties, methods, events, and techniques that have made this subject so hard to master. And when you're done, you'll have a reference that you'll use on the job every day. (Publisher Provided Description, not reviewed)
Lessons from my first Project as a Project Manager
David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it's interesting to see things from the other (not developer or DBA) point of view.
Question of the Day Section Added
Learn SQL Server the fun way through a bite-sized SQL Server question each day. Scores are kept so you'll know how you stack up against your peers in various categories.
Customers Don't Know What They Want
This article on the JoelonSoftware site discusses project management and customer expectations. It has a great discussion of why non-technical users place so much value on what they can see (the GUI) while developers place so much value in what can't be seen (yeah, the code!). It's actually more interesting than that, take a look!
DB2 A Worthy Competitor?
Recently Steve Jones spent a week working with IBM's DB2 database. Read about his thoughts and impressions of this SQL Server competitor.
Dependency Walker
Dependency Walker has been around for a while as part of Visual Studio. Have you tried it? Got the latest version? Andy does a very quick run through of what the product does, why you might need it, where to get the latest version, and why the new version is better than the old one (isn't it always?).
Find out about free Trade Publications
This is a great site that lists all the free trade publications in various industries. You have to meet the criteria of course, but you should definitely check out the offerings.
Importing And Analyzing Event Logs
Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!
Red Gate Web Site Usability Survey
Red Gate asked if we would run a link to a short survey they are working on. Should only take a couple minutes and no personal information is required. They've been an advertiser with us since almost the beginning so we're glad to pass this along to our readers.
Blogs
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Forums
Restore dbs
The below code works for backup files only from local drives. When replaced with...
Fine-tune SQL for better performance
I have been asked to fine-tune the following SQL that was written by a...
Row-level security in SQL server
In this scenario, I seek assistance in implementing row-level permissions for a table named...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers