Explore Sql Server and more!

Tip of the Day - Queries For Debugging Bi-Directional SQL Server Merge Replication

Queries For Debugging Bi-Directional SQL Server Merge Replication

Tip of the Day - SQL Server Database Integrity Check Best Practices

In this tip read about things to consider when running DBCC CHECKDB for different levels of server and database priorities.

Tip of the Day - Resumes: Top 10 Things Managers and Recruiters Evaluate.

Resumes: Top 10 Things Managers and Recruiters Evaluate

Tip of the Day - Monitor SQL Server IDENTITY Column Values to Prevent Arithmetic Overflow Errors

Learn the best practices to Monitor SQL Server IDENTITY Column Values to Prevent Arithmetic overflow error converting data type.

SQL Server User Groups   To have your user group listed or to provide updated information please use the feedback form.

Using a SQL Server Alias for SSIS Package Configuration Database Connection String

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

In my years of T-SQL experience, the MERGE statement has got to be one of the most difficult statements I have had to implement. Oftentimes I would find examples of the MERGE statem

Tip of the Day - Register a SPN for SQL Server Authentication with Kerberos

Register a SPN for SQL Server Authentication with Kerberos

Parameterized Row Filters in SQL Server Merge Replication

I have been tasked with taking a table of sales data and replicating it to multiple locations with each Sales Territory's data going to a different location.

Tip of the Day - Getting Started Querying your Azure SQL Database in PowerShell

Learn how to get start with querying your Azure SQL Database in PowerShell by connecting, invoking cmdlets and returning results.

PowerShell Parameters Part II - ValidateSet and ValidatePattern

When using PowerShell it is helpful to restrict parameter values to ensure proper values are being passed.

Tip of the Day - SQL Server Stored Procedure to Compress Non Partitioned Tables

Check out this SQL Server stored procedure to compress non partitioned tables to save significant storage in your SQL Server database.

Tip of the Day - Validate a SQL Server Backup can be Restored

We need to programmatically validate our SQL Server database backups are not corrupted and that the backup can be successfully restored. We have limited storage and time so we are unable to actually restore the database. Are there any options to validate

Parameterized Row Filters in SQL Server Merge Replication

I have been tasked with taking a table of sales data and replicating it to multiple locations with each Sales Territory's data going to a different location.

Validating PowerShell Parameters - Part I

Learn how to validate integer, string, file path, etc. input parameters in PowerShell as well as see how to test for invalid parameters.

Big Data Basics - Part 5 - Introduction to MapReduce

I have read the previous tips in the Big Data Basics series including the storage aspects (HDFS).

Tip of the Day - T-SQL and PowerShell Documentation With Gists

Learn how to build T-SQL and PowerShell Documentation with Gists including to do lists, linking to web sites, explaining how to, troubleshooting and more.

Pinterest
Search