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.
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 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.
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.
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
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.
When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.
Work on your professional development plan in 2014. Steve Jones has a little advice for you.
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?
You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers