Newsletter Changes for Yahoo Mail
We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.
2010-02-10
505 reads
Press Release
Professional Microsoft SQL Server 2008 Integration Services - Sample Chapter
Get a feel for this book from
2010-02-09
2,108 reads
PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage
Upcoming webcasts in February on the 9th and 10th of the month.
2010-02-08 (first published: 2010-02-04)
1,945 reads
TSQL Challenge 23 - Calculate the uptime and downtime of a system by reading the data from an audit log
It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.
2010-02-08
2,225 reads
PASS AppDev Presents: SQL Server Indexing
While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database. With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T. This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.By Allen White, 2/9/2010, 1:00EST
2010-02-02
584 reads
SQL Server DMV Green Paper
Get a free green paper, an early access look at a new DMV book from longtime author Ian Stirk.
2010-02-02
3,224 reads
Learn about SQL Server without leaving your desk
SQL Server Central, with Pragmatic Works, is offering a new option in learning: high-quality training at a fraction of the usual cost with work absence slashed to zero. Our classes are done online with the same type of quality instructor you would receive from our private classes but done at your own desk. Even though you're doing the class online, the instructor can still hear you while you ask questions and optionally see your screen. Because the class is done in half-day increments, you also still have time to do your job.
2010-02-01
2,379 reads
SQL Saturday #30 - Richmond
Another great one day training event in Richmond, VA on Jan 30. Be sure to attend.
2010-01-28 (first published: 2010-01-21)
1,857 reads
TSQL Challenge 22 - Filling balls into boxes based on rules and preferences
We have got some boxes and balls. Our job is to put balls into those boxes. But, wait a second! The balls should be filled into the boxes based on some rules and preferences configured by the user. Here are the rules.
2010-01-28
2,109 reads
DevWeek 2010 is Coming Up
The time has come again for the UK’s biggest conference for .NET developers and SQL Server professionals. Read the press release about this years DevWeek.
2010-01-27
304 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers