(Jason Brimhall) There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for you nor for your data nor for your database.

(Thomas LaRock) In the previous post I talked about how query optimization works, the role the Cardinality Estimator (CE) plays, and why you should care. Today I am going to break down some of the details about the differences between the old and new CE, as well as show some examples and scenarios.

(Steve Endow) This morning I was working on a SQL query used to create to create new Dynamics GP customer IDs.

(John Pertell) I was going to write about security on FileTables in SQL but I thought I’d write a quick post about creating duplicate files first. This topic came up as part of a general discussion I was having recently on general FileTable usage.

(John Desch) My last blog post was focused on using SQL Server to analyze profiler traces against Multidimensional Analysis Services databases, so I though it only appropriate to follow-up with a post on using SQL Server to analyze profiler traces from a Tabular Analysis Services database.

(Rohit Garg) Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.

(Pinal Dave) In my previous blog I was talking about my friend Jim who was on a consulting assignment and was asking me for some help around blocking. Though the tip mentioned was of help, Jim did reach out to me the day after and had more queries.

(Nagendra kumar) Both session and cache can be used to store the data at the server level (also “Caching” can also be done at client side for static files). Main defference is that Session is created for each user/browser request. It is user specific. and the data stored in session expires when the

(Sheo Narayan) In this article, we shall learn how to enable cascading delete option while creating foreign keys constraints in the SQL Server database.

(Mickey Stuewe) In the early 1970’s, Edgar F. Codd, a pioneer of the relational model for databases, gave us the rules of normalization to help us design and maintain relational databases.