Phil Factor finds much to admire in Microsoft's new Orchard application but is frustrated by a design decision that seems to limit its use to low-volume applications, with less stringent security requirements.
2010-11-08
152 reads
A two-year project involving a team of 15 people, a Future of Monitoring blog, input from thousands of IT professionals, and hundreds of hours brainstorming about how the world is changing has led to Red Gate’s newly released SQL Monitor.
2010-11-08
2,080 reads
Unlike fine wine, you typically wouldn’t want your statistics to be aged. At least for tables that are being updated...
2010-11-08
3,068 reads
I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?
2010-11-08
3,553 reads
In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.
2010-11-05 (first published: 2009-06-16)
16,641 reads
Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.
2010-11-05
3,304 reads
Data structure virtualization is the constructing of a data structure utilizing pieces or fragments from other data structures. This article demonstrates how Data structure virtualization can be performed in ANSI SQL utilizing hierarchical processing techniques to produce hierarchically structured virtualized output.
2010-11-04
3,087 reads
In this next installment of the series on writing codeless applications, David Ziffer looks at the querying of data from the database.
2010-11-03
5,395 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
Fabiano introduces another ShowPlan operator that is used to build a query plan, or perform an operation specified in the DML. Once again, Fabiano demonstrates why it is important to be aware of these operators when getting queries to perform well.
2010-11-03
2,705 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers