Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
2012-02-27
276 reads
Editorials
The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
2012-02-27
783 reads
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
2012-02-24
155 reads
Future Virtual Machines
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
2012-02-23
335 reads
2012-02-21
157 reads
Putting JSON on an equal footing to XML
In SQL Server, we treat XML with a reverence that is disproportionate to its importance. The SQL Server team have indeed gone big on XML, as Michael Cole’s book reveals. The industry has gone big in another direction: JSON.
2012-02-20
626 reads
Programmers v Salespeople
This Friday Steve Jones asks whether you think the salespeople or the technical people are more important to the success of a company. And if they should be better compensated.
2012-02-17
242 reads
Use Your Tools
It's easy to get stuck in a rut and not learn to use the new features and capabilities of your tools are they evolve. Steve Jones reminds you it's worth a little time investment to learn about your tools.
2012-02-15
216 reads
A Valentine for the Community
This Valentine's Day Steve Jones wants to thank everyone in the community for their efforts.
2012-02-14
90 reads
Anonymous Research
Anonymizing data is hard, and Steve Jones talks about some of the problems with trying. Is this something we should be more concerned about this with our corporate data?
2012-02-13
113 reads
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
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...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Locking Hierarchies
Comments posted to this topic are about the item Locking Hierarchies
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;