#ssms

SSM, July 29, 2012

Arthur Dayne has been presented as the  quintessential chivalrous knight. How could he support the atrocities of  Aerys, that even Jaime was horrified by?

Well... keep reading.

Will we learn more about Rhaegar in the next  book? Why did he take almost a year to join the fight against the  rebels, or why did he kidnap Lyanna?

You will learn more, but I can't promise it'll be in the next book. Keep reading.

SSM, January 02, 2002

I have a question which I'm sure you can (and will?) answer. It's about the Tower of Joy. The image we get from Ned's description is pretty powerful. But it doesn't make sense. The top three kingsguards, including the lord commander amd the best knight in ages, Ser Arthur Dayne are present there. Lyanna is in the tower, she asked Ned to promise him something. This, so says the general consensus us little Jon Snow, who is Lyanna's and Rhaegar's. No sense denying this ;)However, what are the Kingsguards doing fighting Eddard? Eddard would never hurt Lyanna, nor her child. The little one would be safe with Eddard as well, him being a close relative. So I ask you, was there someone else with Lyanna and Jon?

You'll need to wait for future books to find out more about the Tower of Joy and what happened there, I fear.

I might mention, though, that Ned's account, which you refer to, was  in the context of a dream... and a fever dream at that. Our dreams are  not always literal.

SSM, August 27, 2000

Second, when Ned Stark and Howland Reed returned  North from Dorne after the events at the Tower of Joy, etc. were they  completely alone during that journey, or were they accompanied by some  household guards, etc. for security?

You'll likely learn more about Ned's homecoming in future books. It's  a long way from Dorne to Winterfell, a journey of months. More than  that I'd rather not reveal just now.

Am I reading things between the lines that aren't  really there, but was Rhaegar and Aerys' relationship not all that it  could be?

There were definitely tensions between father and son. More will be revealed in future books.

SSM, July 11, 1999

I will spare you the rest of my speculations about the date of Jon's birth, since their only real conclusion is that Catelyn seems a little thick when she thinks that Ned fathered Jon as he returned 'Dawn' to Ashara Dayne.

As to your speculations about Catelyn and Ashara Dayne... sigh... needless to say, All Will Be Revealed in Good Time. I will give you this much, however; Ashara Dayne was not nailed to the floor in Starfall, as some of the  fans who write me seem to assume. They have horses in Dorne too, you  know. And boats (though not many of their own). As a matter of fact (a  tiny tidbit from SOS), she was one of Princess Elia's lady companions in  King's Landing, in the first few years after Elia married Rhaegar.

The rest I will save for the books.

SSM, April 19, 2008

Will we learn more concerning Lyanna and Harrenhal?

In today's data-driven world, effective data management and analysis are crucial for any organization. SQL Server Management Studio (SSMS) is a powerful tool that helps manage SQL Server databases and analyze big data efficiently. This blog will guide you through the basics of SSMS, focusing on installing and setting up the software, connecting to various data sources, querying structured data, creating and managing databases, and understanding performance tuning basics. By the end, you'll have the foundational knowledge needed to leverage SSMS for big data analysis.

SQL Server

Installing & Setting Up SQL Server Management Studio (SSMS)

Before diving into data analysis, you need to have SSMS installed on your machine. Follow these steps to get started:

Download SSMS: Visit the official Microsoft website to download the latest version of SSMS. Ensure your system meets the necessary requirements before proceeding.

Install SSMS: Run the installer and follow the on-screen instructions. The installation process is straightforward and user-friendly.

Launch SSMS: Once installed, open SSMS. You'll be greeted with a login screen where you can connect to a SQL Server instance.

SSMS

Connecting to Data Sources

With SSMS ready, the next step is connecting to your data sources. Here's how you can accomplish this:

Server Connection: In the SSMS login screen, enter your server name and choose the appropriate authentication method (Windows or SQL Server Authentication).

Database Selection: After connecting to the server, you'll see a list of databases in the Object Explorer. Select the database you wish to work with.

Data Import: SSMS allows you to import data from various sources, such as Excel, CSV files, or other databases. Use the Import and Export Wizard for this purpose.

Querying Structured Data

One of the primary functions of SSMS is to query structured data using SQL. Here's a basic overview:

Query Editor: Open a new query window from the toolbar to start writing SQL queries.

Select Statements: Use SELECT statements to retrieve data from tables. You can filter, sort, and aggregate data as needed.

Joins and Subqueries: Leverage JOIN clauses to combine data from multiple tables and use subqueries for more complex data retrieval.

Creating and Managing Databases

Creating and managing databases is a critical skill for any data professional. SSMS simplifies this process:

Creating a Database: Right-click on the “Databases” node in Object Explorer and select “New Database.” Follow the prompts to define database properties.

Managing Tables: Within each database, you can create, alter, or delete tables. Use the table designer for a visual approach or write SQL scripts for precise control.

Backup and Restore: Regularly back up your databases to prevent data loss. SSMS provides tools for both backup and restore operations.

Managing SQL Server Databases

Performance Tuning Basics

Optimizing database performance is essential when dealing with big data. Here are some basic performance tuning concepts:

Indexing: Create indexes on frequently queried columns to speed up data retrieval.

Query Optimization: Analyze query execution plans and identify bottlenecks. Rewrite inefficient queries to improve performance.

Monitoring Tools: Utilize SSMS's built-in monitoring and diagnostic tools to keep track of database health and performance metrics.

FAQ

1. What is SSMS, and why is it important for big data analysis?

SSMS is a comprehensive tool for managing SQL Server databases, crucial for big data analysis due to its ability to handle large datasets efficiently, provide robust querying capabilities, and offer various data management features.

2. Can SSMS connect to non-SQL Server databases?

Yes, SSMS can connect to various data sources, including non-SQL Server databases, using ODBC drivers and linked server configurations.

3. How can I improve the performance of my SQL queries in SSMS?

You can enhance SQL query performance by creating indexes, optimizing queries for better execution plans, and utilizing SSMS's built-in performance tuning tools.

4. Is SSMS suitable for beginners in data analysis?

Absolutely! SSMS is designed to be user-friendly, making it accessible for beginners while offering advanced features for experienced users.

5. How do I keep my SSMS up to date?

Regularly check the Microsoft website or enable automatic updates within SSMS to ensure you're using the latest version with all the recent features and security updates.

Home

In this article, we shall discuss how to Install SQL Server Management Studio 21 on Windows Server. SSMS 21 can be installed via the “Visual Studio Installer.” Microsoft’s shift to using the Visual Studio-style installer for tools like SSMS 21 as highlighted during Microsoft Build. This reflects a broader strategy on unified experience, and also for Cloud and Azure Integration. How to install SQL…

Next let's create a function in SSMS. Then we can see how to incorporate that into the SSDT project.

This changes a date string into the format of our DateSIDs.

To pull this into the VS project, click on Tools > SQL Server > New Schema Comparison.

We use the database on SQL server as the source, and we happen to already have that as a connection.

Select the connection, and click OK.

For the target, we can use the SSDT Project.

And click on OK.

Now the Compare button above the source is active. We can click that and see what happens. We can see the list of differences between the source and target. You can turn off the items to not make changes to by clearing checks from the boxes. To actually make the changes, we click on the Update button.

We confirm we want the changes made. Then we can drill into the project in solution explorer, and see that the dbo schema now has a function.

OK, now let's go the other direction and push changes to the database. We create a dapac file for our project by right-click on the solution's name, then click Build.

Then we can right-click on the solution's name, and select Publish. We need to select a target database. For now, I'm just reusing the same database, but it could go to a different SQL server for testing.

Now we can click on publish, and all the new items are placed into the SSMS database.

Eventually, I want to get to the point where I can write an extension for SQL Server Management Studio (SSMS) that will do a few things:

Pretty up what's been entered, or at least get consistent spacing.

Find from a standard place or a specified one and use a list of antipatterns, and show where it's happening in file of SQL commands.

Find (standard or ad hoc) and use tuning hints that would make it easier to tune the stored procedures people write.

Be able to run 2 or 3 across an entire server's worth of functions and stored procedures. Bonus if I could get it to then look at what's running, determine if it's been looked at, and if not check it out (for people that don't store their code on the server).

I've been wanting to try to do this for a while. I know what has to happen, but I haven't used tools to do this since I was in college, and the state of the art is much more advanced. And in some ways, a bit more backwards.

I'm working in SQL, but actually we use T-SQL (aka Transact SQL) which is Microsoft's variant of the language. And is there documentation of T-SQL? Of course not. Why would anything change in their corporate wisdom? They started putting out something called the ScriptDOM (DOM = document object model), and that will create an Abstract Search Tree that we can then process to find problems.

Does it work on it's own, using unspecified scripting languages? Sure. Does it work in SSMS the most used tool for SQL at work? Nope. Does it work natively in Visual Studio (VS)? Nope.

Introduction Have you ever noticed that when you view query plans in SQL Server Management Studio (SSMS), scalar user-defined functions (UDFs) appear in the estimated plan but mysteriously vanish from the actual plan? In this article, we’ll explore the reasons behind this behavior and discuss its implications for query optimization and performance. Understanding Scalar UDFs Scalar UDFs are…

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. Microsoft has announced the latest release of SQL Server Management…