Since SQL Server has many deployment options, like editions, server locations and so on, different situations might need different specific configurations. However, pointing the application to the ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

We need Dynamic SQL to build the object from text strings. Another problem to deal with is that the source for some database objects can exceed 32,767 characters, the maximum limit for VARCHAR2 ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

"An object explorer allows developers to easily make connections to their SQL servers and databases and explore the hierarchy of the SQL Server instance," Yu explained. "Users can also easily launch ...