Email Alerts
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more. Tip
-
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features. Tip
-
Warned about table changes in SSMS? Here’s a workaround
Editing tables in SQL Server Management Studio and getting this warning, “Saving changes is not permitted”? It happens when the table needs to be re-created. But don’t fret. This change in SQL Server 2008 R2 can be undone with a simple tweak. Tip
-
SQL Server merge replication using IIS
In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS). Tip
-
Where to look next for BI applications? Try the cloud
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you? Tip
-
Microsoft brings PHP integration to SQL Server Reporting Services
PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports. Tip
-
Open source tool simplifies database synchronization for SQL Server
A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases. Tip
-
Optimizing SQL Server indexes -- even when they're not your indexes
When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed. Tip
-
Top tips and tricks for SQL Server database development
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more. Tip
-
Managing the development lifecycle with Visual Studio Team System 2008
Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle of your SQL Server databases. Tip