Sabbatical
Steve Jones is taking a sabbatical this year and has a few thoughts on what this means for his career.
An Introduction to Windows Azure Table Storage
Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just containers of rows of data. Mike Wood describes the practicalities of getting started with using the system.
Relational database or graph database? Why not have both?
SQL Server may not be the best solution for every problem, but we have the means to extend its capabilities by linking it to external resources; in this case, using SQLCLR to query a graph database.
The Holiday Challenge
The holiday time period isn't always a fun time for IT pros who can get stuck working more than usual. Steve Jones talks about some of the experiences he's had.
SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines
This article describes how to use the new wizards in SQL Server Management studio to get access to Windows Azure and then create and configure your VM.
An AlwaysOn Bug with Service Broker Transmission Queue
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
Data Science Laboratory System – Graph Databases
Graph database are an intriguing alternative to the relational model. They apply graph theory to record the relationships between entries more naturally, and are a good fit for a range of data tasks that are difficult in SQL. Buck Woody gives an introduction to Graph databases and shows how to get Neo4J up and running to get familiar with the technology.
A Simple Recursion Finds Joins
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
Budget for Training
Work on your professional development plan in 2014. Steve Jones has a little advice for you.
Fighting Tooth and Nail for Performance
You need a SQL Server-based application that will work with huge amounts of data and must perform calculations of startling complexity. How far will you go to deliver the required performance?
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers