In this exercise, you will use the .NET Compact Framework and SQL Server CE to configure merge replication, build an application user interface, subscribe to a SQL Server publication, modify and synchronize data, and resolve conflicts.
Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.
SQL Server 2005 is on everyone's mind, especially with SQL Server 2000 almost 5 years old. On Monday, April 18, Microsoft made an announcement that the April CTP was available, but there would be no Beta 3. Read Steve Jones take on this announcement as well as a few more details.
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
Did you know that you can obtain the execution plans for your SQL Server 2000 queries using Profiler? It is an interesting concept, especially when you need to troubleshoot the queries on a system that you did not develop and cannot obtain source code for. SQL Server guru andy Dyess brings us the technique you can use to find those queries and execution plans.
SQL Server 2005 is chock full of new features. You may have heard that you can write stored procedures in a CLR language like C# or VB .NET, but TSQL is here to stay. One new great feature adds the functionality of a Ranking expression that can be added to your result set that is based on a ranking algorithm being applied to a column that you specify. This will come in handy in .NET applications for paging and sorting in a grid as well as many other scenarios. We are going to take a look at the Ranking functions new to SQL Server 2005 using the new AdventureWorks database on the February 2005 Community Tech Preview.
As the online news service called NewsScape moves into its sixth year, it exhibits a lot of the characteristics of a child at the same age: It has a huge appetite for information, grows by leaps and bounds each year, and makes those who oversee it wonder if they can maintain control as it gets bigger. It is maintained by "a man and a dog – an aging golden retriever named Sambucus," according to the man, Andrew Clarke.
This paper discusses the types of backups that are available in SQL Server 2000 and how backup functionality can be used in a disaster recovery plan. It includes general recommendations on how to improve backup and restore throughput and several case scenarios.
Two MVPs at one shot in this one. SQL Server MVP Hilary Cotter has written a book on replication, one of the very few there are on this topic. And it's presented as a review by MVP Adam Mechanic, a regular visitor to SQLServerCentral.com. If you're looking for replication help, check out this book.
This article presents an excerpt from the book, Microsoft Reporting Services in Action, by Teodor Lachev. Learn how to implement advanced report functionality using custom code.
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers