Email Alerts
-
Working with IntelliSense in SQL Server 2008 Management Studio
IntelliSense in SQL Server 2008 Management Studio provides easy access to language elements when writing T-SQL queries. Knowing the basics can simplify coding in a big way. Tip
-
Determining the source of full transaction logs in SQL Server
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem. Tip
-
Using the OPENROWSET function in SQL Server
Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access. Tip
-
Loading data files with SQL Server's BULK INSERT statement
The BULK INSERT statement enables the bulk-loading of data files into SQL Server databases. Get instructions on how to use it, along with details on the FIELDTERMINATOR and CHECK_CONSTRAINTS options. Tip
-
Importing and exporting bulk data with SQL Server's bcp utility
The bcp utility is a command-line utility in SQL Server that allows for the customization of importing and exporting data from text files and SQL Server tables. Tip
-
Testing transaction log autogrowth behavior in SQL Server
Shrinking SQL Server transaction logs can undermine server performance. An expert runs various tests to demonstrate how transaction log files respond to several T-SQL commands and to determine whether shrinking files is necessary. Tip
-
Securing SQL Server with access control, login monitoring and DDL triggers
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues. Setting up security configuration in the beginning can prevent data breaches. Learn how to s... Tip
-
The sqlcmd utility in SQL Server
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting started using sqlcmd in interactive mode, and shows you h... Tip
-
How to create a SQL inner join and outer join: Basics to get started
When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Tip
-
Implementing security audit in SQL Server 2008
If you're a DBA tasked with producing detailed audits tracking database use, take a look at these capabilities in SQL Server 2008 where the process is much easier than in earlier versions. Tip