Total Database Information At Your Fingertips Part I
This article will help to get some basic information from your databases that may help you in different situations.
A Red Gate Meetup in San Francisco
Join Neil Davidson, Joint CEO of Red Gate Software, for a meetup in San Francisco on Aug 25th. Come talk software, databases, and development with other like-minded people.
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.
Back to Basics
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
Configuring Database Mail with Powershell and SMO
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
Keeping Your Soul
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task
The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
Tricky Questions
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers