Paging Data with T-SQL
Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.
How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
Power View for Cubes
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.
Centralizing SQL Server Express Job Scheduling
I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?
Connecting to AdventureWorks on Azure
A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.
How Maintenance Plans are a Big Plus for SQL Server Administration
SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.
Morphing Microsoft
Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.
Powershell for DBAs
Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.
SQLServerCentral Hosts AdventureWorks on Azure
SQLServerCentral and Red Gate software have agreed to host the AdventureWorks database on the Azure platform and give free access to anyone that wants to practice querying it.
Azure SQL Database Maintenance
It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers