SQLSkills Immersion training in London
A wrap up from MVP and expert Gail Shaw on her experiences of training with SQLskills.
Time for a ROWID?
Steve Jones looks to the future of SQL Server and wonders if we ought to add a rowid to the internal structures.
System Monitor (Perfmon) Counters for SQL Server 2005
Capturing performance monitor counters is of great value to understand how SQL Server is behaving at a macro level, that being how overall resources are being used within the engine. Without this data it is difficult to determine where the performance issues are occurring. Capturing the metrics has been traditionally from Performance Monitor either on an ad-hoc basis or setting up a log to capture the values on a predefined basis.
NewSQL Can Save the World
A new breed of products use the relational model and address the scalability concerns of many RDBMSes. Today Steve Jones talks about NewSQL databases.
Speeding up database access Part 2 - Pinpointing Other Bottlenecks
Part 2 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.
Migrating Microsoft Access Databases to SQL Server 2008
Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.
How to create a CLR assembly on a remote server with limited permissions
How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available
Patches for SQL 10 and Techniques for SQL 11
Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.
SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
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