mmeshref

So what information you're seeking that you can't get through profiler?

You can use SQL profiler to do these operations of listening to what is done on the server

Try this: Enabling Remote Connection in SQL Server

SQL Server Aggregation Part 1 Aggregation refers to the collapse of a larger set of rows into a smaller set of rows. Typical aggregate functions are COUNT, MIN, MAX, SUM, and AVG. Scalar Aggregation Scalar aggregates are queries with aggregate functions in the…

Just a small comment, SQL authentication is very weak compared to Windows Authentication, and the direction is to disable it in the future (many new SQL Server features already don't support SQL Authentication)

As I told you, databases are designed to hold data forever, so what you'll do is to kick an agent job daily which has one job step that delete all rows which are 60 days or older

Just put in mind that a search like this is very expensive as the indexes won't be used and SQL Server will perform a scan over the whole table

There's a book that teaches all this, and it's very good and using C# in examples, it's called: Framework Design Guidelines: Conventions, Idioms, and Patterns for Reusable .NET Libraries

You have two ways to do this: Either have an agent job that runs daily and deletes anything that is older than 60 days Or To have a cleanup plan done in BIDS (Business Intelligence editor) to do this for you But agent is easier to do, and BIDS build an agent j…

You don't need to download them all If you tell me what you will use SQL Server for, I can tell you which one you can use :)

Really nice article :) I touch this a lot in my day to day job, we've a simple rule when we design object models here, we set all our data structures to be immutable unless they need to be otherwise, it's better to design them this way, because this gives you …

Have you solved your problem?

What are you using it for?

That's a really good effort that I need to thank you for :) Did you use any translation software (i.e. google translation) or you did it yourself? Because some of the terms are really hard for me to understand (Oor maybe it's me as I am not used to read teachn…

SQL Server Joins Part 2 This lesson will be about Hash Join and Merge Join. Merge Join Unlike the nested loops join which supports any join predicate, the merge join requires at least one equijoin predicate. Moreover, the inputs to the merge join must be sorte…

Do both the machine belong to the same domain? If yes, are you an admin on the server machine or at least having permissions to the database you're trying to connect to? One way of discovering the answers for this questions is to try to connect to SP00 from SP…

I am glad you liked it, if you know of someone who can translate it to Arabic so everyone here could benefit, this would be great :)

SQL Server Joins Joins are one of the most important operations performed by a relational database system. An RDBMS uses joins to match rows from one table with rows from another table. For example, we can use joins to match sales with customers or books with …

SQL Server Indexing Part 2 In this lesson we will finalize the indexing by talking about seek predicates and give some examples to show how indexing work Seek Predicates Before SQL Server can perform an index seek, it must determine whether the keys of the ind…

SQL Server Indexing Part 1 In this lesson, we'll be talking about how Indexing work. Table Scan vs. Table Seek Scans vs. Seeks Scans and seeks are the iterators that SQL Server uses to read data from tables and indexes. These iterators are among the most funda…