Version Control

External Article

Database Version Control

  • Article

By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.


4,275 reads

Technical Article

Table rowcount

  • Topic

Does any one have a script handy that gives you the rowcount of all user tables on a database. I have one but it gets the result from sysindexes which sometimes is notuptodate. Also I wont prefer anything witha  cursor as that might slow down the server. any scripts other than these two.Thanks


Technical Article

RE: replication between 2 SqlServers

  • Reply

If you're in a workgroup instead of a domain... there's one possibility that I can think of.  The administrator account you're using is a local machine account, I'm assuming.  If you're using a local account, it really won't be able to talk to the other machine.I'm in a domain, and using an account with admin […]


Technical Article

what is the sql server equivalent to mysql limit x, y

  • Topic

HiI've had to do a project in SQL Server and, although I haven't encountered it yet, I'm curious.  In MySQL you can say 'limit 50, 50'  to start at the 50th record and return 50 records, i.e. returns records 50 - 100.  How do you do the same with SQL Server?  I know about top […]


65 reads


Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers