What are /r/SQLServer's favorite Products & Services?

From 3.5 billion Reddit comments

Hi there, thank you for participating in the AMA! The most direct feedback path from customers to the tools team is still through Connect.Microsoft.com. Our team leader Ken (@sqltoolsguy on Twitter) has chartered us to become much more responsive to issues posted to that site. We are making a concerted effort to resolve items we know we won't fix and to assign items that warrant a fix to our backlog and to communicate a time estimate in the Connect item. The backlog is big so it may take a while to get through it. Meanwhile, the DBA/MVP community has created its own channels where SQL tools team members participate. The Trello board at https://trello.com/b/M9NmFPfv/sql-server-management-studio-2016-enhancements is building momentum, and there's a new slack channel at SqlCommunity.Slack.Com. More of us are trying to monitor forums like #sqlhelp, reddit and stackoverflow on a regular basis as well.

It's free for everybody! Same with the Developer Edition of SQL.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

https://www.microsoft.com/en-us/sql-server/application-development

SQL Server Developer, BI Backend Developer, Data Architect, stuff like that.

The Kimball Group Reader (Amazon link, without a referral or whatever) is a must read in the business of DWH and BI. Coincidentally, I haven't read it (impossible to get where I live), so don't ask me for an opinion if it's any good!

> I try to use the same principles of code cleanliness, separation of concerns, etc from .Net dev.

The first thing I imagine when I hear something like that is the person happily converting code into user defined scalar functions (I hope you don't use them). Not all rules from procedural development apply to SQL, remember that!

Do a google search for your job title and location and there are plenty of websites that will give you numbers, such as Glassdoor, Indeed, etc.. Here is an example for Tennessee. I have to admit these numbers have always seemed kind of skewed too high for me, so your mileage may vary. The key is experience on the job I suppose.

In my personal experience: When I first started SQL development (learning on the job, much like you) I was making $28,500 in CT (2007). I left that job after around 3 years making $36,000. Since then, I wasn't able to get a decent bump until I entered the Business Intelligence realm. When I branched out and started doing Business Intelligence/ETL work with Microsoft SQL Server the compensation was much higher.

SSMS is just the console you use to connect to SQL Server. Have you installed SQL Server Express? I assume this is a home lab and express is free.

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

check the sql server logs and see if any settings were changed around the time it started to grow. hopefully you aren't logging successful logins... scroll, scroll, scroll.

2nd: Operations on temporary tables, table variables, table-valued functions, and user-defined tables are logged. These are called user objects. Sort operations in tempdb also require logging for activities related to page allocation. The log size requirement depends on two factors: how long it is necessary to keep the log and how many log records are generated during this time.

linked servers can grow it.

distincts can grow it.

http://serverfault.com/questions/61479/my-templog-ldf-is-huge-45gb-what-if-anything-should-i-do

has some tips to check too.

There's no simple way to just have a short alias for SSRS reports. First option is to have a DNS redirect to the report, but that's difficult to maintain. Alternative that I've implemented for internal purposes in the past is YOURLS. It allows you (or anyone really) within the company to create and manage short URLs. If you can convince your server/applications team to run it, this is likely your best bet.

If you're having trouble with getting through the installer, are you really prepared to be exposing it to the outside world while running it on a desktop OS?

Does it have to be local? You have a 1GB database running on Azure for $10/month. Or even a small dedicated VM running SQL Server, already set up & configured for you, for a nickel an hour (power it down when you don't need it).

As others said download ssms and install it on your machine. Then connect to the server.

If you can't connect, it may be the SQL admin needs to add your account to the server and configure your permissions. Though you may already be in an Active Directory group with rights.

SSMS (SQL Server Management Studio) is just the interface to access SQL server instance(s). You still need SQL Server installed n configured.

Look for download versions of Developer or Express of SQL and watch a couple tutorials (first one that came up on search in YT, no idea if its good)

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Look for Developer edition, it is free to use for development and learning situations like yours.

Follow the prompts you should be fine

https://www.git-tower.com/learn/git/ebook/en/command-line/basics/why-use-version-control

You can do stuff like

• Show all of the source changes between versions x and y
• Easily (well, with less difficulty at least) remove features which will not be ready for release from the dev branch. You can retain the feature branch, complete it next sprint, and merge it back in
• Allow mutliple developers to work on separate features in parallel, by providing a framework for harmonising conflicting changes
• Keep a full audit trail of changes - who did what, and when
• Support automation - e.g. a pull request into dev requires a clean merge into master to be possible, and the result to build successfully and pass automated testing, before it can be completed

In short, it provides a structured way to manage development.

This tip may help..

SELECT T.*, ISNULL(T.DATE,'MY STATIC VALUE') FROM myTABLE1 T RIGHT JOIN (SELECT DATE FROM DATES) D ON T.DATE =D.DATE WHERE D.DATES BETWEEN ? AND ? AND OTHER CONDITIONS..

If you do not have DATES table, may use below query as inline query in place of it: SELECT TOP (DATEDIFF(DAY, '20160101' , '20180101') + 1) Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate) FROM sys.all_objects a CROSS JOIN sys.all_objects b;

https://stackoverflow.com/questions/17529860/how-to-list-all-dates-between-two-dates

Maybe the service account doesn't have the appropriate windows rights (https://technet.microsoft.com/en-us/library/bb457125.aspx).

Here's a super user question/answer that shows how to list the rights for a partciular user using NTRIGHTS.EXE or PowerShell. http://superuser.com/questions/309360/windows-7-equivalent-for-ntrights-exe

Compare the service account to an account you know that works. Specific rights that might be in play include "Access this computer from the network", "Logon as batch job". plus who knows what else :)

For stand alone servers you can dig through Local Security Policy, Local Policies -> User Rights Assignments (shows rights by name and which user has that right). Kind of a pain in the ass because it's not by user... but if you're on a standalone server it's ok.

Your list is very nice. Looks like you chose the right books too. I'd just add the excellent MCM readiness videos from Paul Randal and others. Reading, practicing the above topics along with watching these videos for respective topics will help.

Do you have a copy of Visual Studio 2012 Professional or greater? You can install ankhsvn and you can execute SQL from Visual Studio 2012 with CTRL+Shift+E instead of F5.

The easiest way is to add them directly to the registry. Make a backup of the existing entries first in case you royally screw things up.

More Info:

http://serverfault.com/questions/424267/create-a-odbc-connection-from-file-bat-at-windows

https://msdn.microsoft.com/en-us/library/ms712603(v=vs.85).aspx

Do you know what version of SQL Server?

There are a bunch of virtual labs here that give you hands-on work with SQL Server 2008 and 2008 R2. I'd recommend

• TechNet Virtual Lab: Microsoft SQL Server 2008 Online Operations
• TechNet Virtual Lab: Microsoft SQL Server 2008 Data Recovery and Preventative Techniques
• TechNet Virtual Lab: Multi Server Management in Microsoft SQL Server 2008 R2

They won't make you an expert, but you'll be comfortable with the basics. Beyond that, as others said - if you don't know an answer, tell them. I would also strongly suggest being honest about your background and your ability to learn - let them decide if you're a fit.

While a newb DBA could pick up the necessary concepts on the fly in a smaller company, or as a new guy on an existing team, you absolutely do not want to find yourself as the sole DBA owning several hundred production servers.

Have you looked at the MERGE command.

It performs insert, update, or delete operations on a target table based on the results of a join with a source table.

It doesn't add any new functionality to SSMS and doesn't seem to be that well adopted yet (it is in preview of course).

But I have to mention SQL Ops Studio. There are some nice extensions being built already.

https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is?view=sql-server-2017

I really enjoyed the CBT Nuggets videos. I happened upon them for free, but they offer $99 a month subscriptions which isn't so bad if you have your own lab to work with.

http://www.cbtnuggets.com/it-training-videos/microsoft

Just search for SQL Server 2012

Microsoft SQL Server 2012 T-SQL Fundamentals is awesome too, and possible more helpful that the above info. http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145

You might be able to find the above book in PDF form if you look hard enough...

A couple of suggestions to try.

SqlBulkCopy also supports IDataReader as a source so you may get a boost using CsvReader directly with the SqlBulkCopy.

You might also try wrapping up the whole thing in a transaction. Since you're setting single user mode there shouldn't be any contention or locking issues.

Grab yourself a copy of VirtualBox then go to Microsoft's Run It on a Virtual Hard Disk site to download pre-built copies of Server as well as SQL Server for 180 day trials.

This will give you a jumping off point for testing SQL Server installs as well and testing with a prebuilt SQL Server instance.

SSMS + SQL Complete from dbForge:

https://www.devart.com/dbforge/sql/sqlcomplete/ordering.html

it adds functionality to ssms..... use it once and you'll feel like ssms is broken when you're without it.

(also if you have sql server installed on the machine you're using ssms on, even if you connect to a remote sql server you'll have added gui functionality)

On a more serious note, get more information on the problem that he is trying to solve. People don't decide to do something crazy like this out of the blue. Work to understand the problem and try to see how he came to that decision.

You need to find the where the flaw in his logic started and get him to explain that detail to you until he understands it. I use this approach all the time. I have a keen eye for these types of mistakes that people make. But I get a lot more millage if they figure it out while they are explaining it to me than I do if I just point it out and say they are wrong.

If this is one value saved every 15 minutes, unless this is for hundreds of thousands of sources, the performance and space will be a non issue. But if you build this with columns instead of rows, it will cost 96 times more do develop. You have to duplicate a large chunk of code 96 times to work with 96 columns. Sure Dynamic SQL can be done but it creates code that is just as hard to maintain.

It could be possible that SQL is not your solution at all. This goes back to understanding the problem. I have used circular databases for performance data before. It is a set size, will never grow, automatically discards old data, and can hold data at different resolutions. RRDtool is the one I use: http://oss.oetiker.ch/rrdtool/

Maybe give Directus a try? It sounds like it may do what you're looking for. It supports connecting to a SQL server database and you can give fine-grained permissions to individual users for managing the data in the database.

Go to the SSMS website. On the right side of the page is a link that says "Previous Versions".

Although I'm not sure why you're running Windows 10 from November 2015. That's frighteningly insecure.

Can you try installing a newer version? https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

I would try running a repair on the .NET framework or a sfc /scannow

Take a look at the Power BI gateway too when you get a chance. This would bypass your issues and allow the reports to update from anywhere, not just your desktop.

https://powerbi.microsoft.com/en-us/gateway/

SqlWorkbenchJ. It's multi db, and the maintainer is very responsive. I use it for DB2.

Jetbrains DataGrip. Made by the Resharper people.

This blog will help you get the shape file into sql so you can check it against your lat/lon: https://alastaira.wordpress.com/ogr2ogr-patterns-for-sql-server/

The guy who wrote that blog also wrote a fantastic book on spatial data in sql server that is worth picking up if you have to support this stuff: https://www.amazon.com/dp/B0089NVTOG/ref=cm_sw_r_cp_awdb_KYZT2SM3DQX4NX1QNM30

This book https://www.amazon.com/Troubleshooting-SQL-Server-Guide-Accidental/dp/1906434786/ref=mp_s_a_1_3?dchild=1&keywords=sql+for+the+accidental+dba&qid=1617244119&sr=8-3

as well as Brett Ozar have been very helpful for my team.

Push the complexity down. Abstract the data interface further. In the front end have simple logical interfaces to: GetOrder CreateOrder GetCustomer CreateCustomer SaveOrder

Have a data access layer that is responsible for fetching data from the database. Being stored procedure, view or whatever.

I assume this a web app? Have you built it to leverage caching? Are you only hitting the database when you need to? My guess is you are not. I've worked with some highly performant websites using C# and SQL Server and they always had a few layers in the app so that the client was only dealing with objects or datasets that could be cached by the web server (where appropriate) and worked with general constructs for working with data having complex relationships.

Found a link that may help. As mentioned in one of the replies, the data access layer is part of the idea of loose coupling. Something that many of todays ORM's and Linq make less obvious, but still important. https://stackoverflow.com/questions/59942/what-is-the-purpose-of-a-data-access-layer

As a good basic primer on administration you could use a slightly older book.
TribalSql from MidnightDBAs

https://www.amazon.com/Tribal-SQL-Diana-Dee/dp/1906434808

I'm in pretty much the same situation, recently moved from dealing with Oracle as a managed service, to now a fully in-house SQL Server estate where I need DBA skills too.

I used this book, I'm about 2/3rds through so far, and I'd recommend: https://www.amazon.com/Microsoft-SQL-Server-2019-Beginners/dp/1260458873

(I'm in the UK but have found the US Amazon link, hopefully its available to you!)

Another option, but isn't SSMS, is DBeaver. I needed this to work on a DB from another vendor and then discovered it can connect to MSSQL. It has some neat, configurable SQL formatting (CTRL+SHIFT+F).

https://dbeaver.io/

I asked for some resources in this post, and since then, I decided to start by going through the book "Pro SQL Server On Linux" by Bob Ward.

Joes2Pros is the first stop I think. 5 books, written in plain English by a former crab fisherman. 1-3 for development, 4-5 for DBA skills.

https://www.amazon.com/Beginning-SQL-Joes-Pros-Hands/dp/143925317X/

After that, Brent Ozar for the deeper dive.

Please take a look here. (Google if you prefer.)I'm not trying to be a dick, but when I get stuck I always search first and I think you'll find this is a commonly answered question.

also:

• don't install sql server engine on the C:
• data files on one drive (MDF, NDF)
• LDF files on another drive
• tempdb MDF's on another drive. start with 4 identically sized with identical growth to maximize perf.
• the LDFs for tempdb can go with the other LDFs.
  
• reporting data on its OWN drive.
• backups elsewhere too

http://technet.microsoft.com/en-us/library/cc966412.aspx

also: format your data drives in 64k chunks.

for all the dbs, set the autogrowth to a reasonable size, not percentage. 256Meg or 512Meg.

make sure fast disk init is on.

You mean MCM. Yes, I heard Microsoft maintains great standards for MCM. Take a look at this MCM readiness videos for SQL Server 2008 to get a feel of it.

ANSI_NULLS off was deprecated as of SQL 2008 and will be removed, so irrespective of the ANSI SQL-92 standard don't expect it to be functional in SQL v-next.

ref: http://technet.microsoft.com/en-us/library/ms143729(v=SQL.100).aspx

Here's a fairly large study http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923.html

We've personally been using the Intel X25 2nd gen SSDs in all our SQL Servers for about 2 years. No failures yet, our busiest disks write 2GB per hour pretty much 24/7. Not quite the scale of your toys of course.

I mean I'm sure they'll fail eventually but in the same time we've had dozens of spinning disks fail in other servers. And you have to remember that one SSD replaces several HDDs in terms of read / write performance so we have fewer SSDs in our SQL Server than before which increases overall array reliability.

Download a copy of Pro Git and dive in!

https://git-scm.com/book/en/v2

If it's a small codebase and small team, you can probably get away with simply using the master branch, with occasional short-lived feature/experimental branches for longer (i.e. multi-day) work units that aren't ready for the master/release branch. If you need a slightly more mature workflow, add a dev branch where you test and QA stuff before merging it into master for release.

Hello Everyone.

First, I want to thank everyone for their feedback. It was very informative and useful. I appreciate it.

From that feedback, I did find a solution. Due to the data volume, it took a long time to implement and I wanted to verify it before I reported back. Here is what I did:

1. Removed the partitioned table – I was surprised that a partitioned table could negatively impact performance, but it seems from my experience this is true. I am trying to assess the value in partitioned tables for my application, but I am going to create a different post for this.
2. Removed the clustered column store index on the table – this wasn’t really a suggestion, but this index was not helping how this table was consumed. It did help with the data volume from the compression, but because I wanted to try different approaches with non-clustered indexes, I got rid of it.
3. Added three fields to the table:
   1. Fill_Date int,
   2. Fill_Year smallint,
   3. Fill_Month smallint,
4. Populated these based on the Fill_Date_Time field, which is a date/time field.
5. Created a non-clustered column store index on these fields:

​

CREATE NONCLUSTERED COLUMNSTORE INDEX [cci_SRC_Prescription_Fills_Fill_Date] ON [SRC].[Prescription_Fills] ([Fill_Date], [Fill_Year], [Fill_Month])

The query now runs in 2 to 3 minutes. The new query plan won’t parse in Paste the Plan, but here is an image: [Link]

My next step is to just create a non-clustered column store index on just the year and month fields.

CREATE NONCLUSTERED COLUMNSTORE INDEX [cci_SRC_Prescription_Fills_Fill_Date_2] ON [SRC].[Prescription_Fills] ([Fill_Year], [Fill_Month])

I am glad there is a community like this because sometimes you just can’t see a potential solution without airing it out with others. Thanks!

Yep! They are all on the sqlmigration github repository.

The slides are here though I recommend downloading them, because PowerPoint Online overlaps the videos over the text.

The video will be posted soon on Youtube :)

Go to Leet Code . https://leetcode.com/

Create an account, and go to "problems" and choose Database. There are tons of problems to solve from easy to hard.

**You can choose which DB you want to use, and its all done online.

You can download SQL Server to your personal computer or use the cloud. Developer edition and Express are free. Creating a database is literally one line of code.

CREATE DATABASE Derp;

You are correct, Amazon S3 pricing was dropped again in November. Standard is around 2 cents per GB and their infrequently accessed storage is around 1 cent per GB. Here's the pricing and description of both https://aws.amazon.com/s3/pricing/ I would suggest you purchasing Cloudberry SQL Backup (you can setup Full image and SQL backup jobs.) You can compress both the full and incremental so your cost is even lower. It's going to be much less and more reliable than your hosting provider. You can setup a trial of both AWS Amazon and Cloudberry SQL Server (runs on Windows server) and find out exactly what your spend will be. You can even setup alerts if your monthly spend goes over a certain amount. Good Luck!

/r/relationships may help with your dating nightmares ;)

One of the biggest problems is that sometimes it's simply not possible to unambiguously determine a date in a random format - is "04-18-20" April 18, 2020 or April 20, 2018? "10-11-12"? - hell, this date can be whatever you want it to be.

Honestly, what I'd do is break out of SQL Server and do something with regex. The following regex will capture a list of at least three groups of digits separated by one or two non-alphabetic characters. You'll notice it catches the "2" in "File2" - sadly that will require some code to record and check the separators, too. Even that's a challenge with something like "File 2 2018 04-28".

(?:(\d+)(?:[^a-zA-Z]){1,2}){3,}

https://regexr.com/53po9

Nevermind, I found it.

I looked at sp_add_log_shipping_primary_database (http://technet.microsoft.com/en-us/library/ms182718(v=sql.105).aspx) and it has an option called @backup_compression.

I checked the text of the procedure and it is inserting a record into log_shipping_primary_databases. Looks like in my setup the value of the field backup_compression is 1 which means the backups are already being compressed.

Yes. Here is some information about it. I’m struggling to find a good MSDN article on it, they exist. I’ve used this both from ASP.NET MVC and WPF. The former as recent as 2020!

https://coding-examples.com/csharp/rdlc-report-reportviewer-control-in-c/

I believe the reportviewer controle that supports this is in this package:

https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/

There is a one more SQL Recovery software which is highly recommended by Microsoft MVPs and database administrators. Stellar Phoenix SQL Database Repair software repairs corrupt MDF and NDF files. It supports all SQL Server versions. Read more : https://www.stellarinfo.com/sql-recovery.php

I am really into the entire elastic stack. It has a steep learning curve but the value of the ”big data” approach inside elastic suits me well. https://www.elastic.co/blog/monitoring-microsoft-sql-server-using-metricbeat-and-elasticsearch sadly the open-source/basic license does not support alerting out of the box. For classical alerting such as memory, CPU, whatever we still use Nagios which sends to VictorOps which automatically enriches the alert with a query for the time in elastic. Additionally, we feed firewall, switches, application performance and file logs into elastic, which can be easy to correleate. And it is all based on a free stack.

Here's a couple I've used in the past...

Tutorials Point SQL

W3 Schools SQL

Hope these are at least a little helpful :)

Hi! That's a nice question you've asked. The most popular 5 tools are

1. Skyvia
2. Talend
3. Python
4. Azure Data Factory
5. AWS Glue

Read more about them here

I'm no expert but it sounds like you're after something like SQL Server Reporting Services (SSRS) or Power BI

Location of backup software: local, on the same host as the SQL Server instance

SQL Server 14.0.3048.4

Windows Server 2016 Datacenter edition, 64-bit OS, x64-based processor

AWS r5d.2xlarge: https://aws.amazon.com/ec2/instance-types/r5/

Are you looking to version the scripts that you use, or are you looking to enforce change control? Those are two different things, the former a lot easier than the latter.

The git command line isn't too onerous, but if your guys feel like they need a GUI, Sourcetree is pretty good (and free) But you definitely want your team leaders to at least give https://git-scm.com/book/en/v2 a quick read.

To centralize things and display them nicely, GitLab is a good choice for a self-hosted Githublike. The community edition even offers LDAP auth, though they kinda hide the feature and make you work for it.

I did see another link that indicated the issue was login failure for the account selected by the wizard - http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_27574658.html. In a nutshell they did this - On the screens where you select the Source/Destination server or if you saved it as a SSIS package then you must edit the package and inside the package connection manager.

Click the "Use SQL Server Authentication" and provide credentials to use a SQL login.

Then discovered that the account was not set up as a credential for proxy account. After setting up the credential and proxy for that login the SSIS transfer package worked.

Hi,

Common causes of error in SQL Database -

• Changes in SQL Server Account.
• Virus/Malware attack
• Accidental deletion of data.
• Issue in MDF and LDF files.

To fix it there are manual ways to do it-

• Use log file or a backup file to repair SQL database.
• Use command DBCC CHECKDB & DBCC DEREPAIR.

Manual ways to do this are many which helps you to resolve this issue but sometimes users need to repair SQL Database with creative approach to eliminate unnecessary issue in SQL Server Database and have successful SQL Database recovery.

Hope, this will help you.

Thanks

Awesome. Thanks. I built a new monitoring tool. We're trying to simplify uptime monitoring for everything. But we're still new, and working on SQL. Would love to know what you think: http://www.happyapps.io/

As I think, a database is asset for any organisation. You should try a Stellar Phoenix SQL Database Repair Software because, it is recommended by Microsoft MVPs and database administrators. Read more: https://www.stellarinfo.com/sql-recovery.php

https://sqlbackupandftp.com/ I use this, it's a seriously useful utility, with excellent control history purging, push to cloud etc etc. I am simply a user, but grateful!! BTW, it does what you asked

Thanks. You can't automate any other maintenance tasks either like rebuilding indexes. The backup thing I got around with this 3rd party backup solution. It is much better than anything built in to SQL server. It is not expensive either. I highly recommend. https://sqlbackupandftp.com/

https://www.sap.com/products/powerdesigner-data-modeling-tools.html

I used this when it was owned by Powersoft. Hopefully SAP has revived it after Sybase let it die a slow death. I have also used Visio, MS diagrams in ssms, and Erwin which was also good.

I've had it consume a lot of memory before, but not crash. The undo buffer uses a ton of memory, as do large result sets, Intellisense, and syntax highlighting large scripts. Supposedly Ctrl-Alt-Shift-F12 forces a garbage recollection, but, hey, so does Ctrl-S, Alt-F4.

As for OP's actual question, I really like Aqua Data Studio for a query analyzer. We have it because we had to support multiple vendors and this one is vendor agnostic (we've used it with SQL Server 2000, SQL Server 2008/2008 R2, Informix, DB2, MySQL, PostgreSQL). It's Java-based, but as long as you configure the JVM in the application folder to user more memory it runs just fine even with very large queries. It's not cheap, but it's not RedGate pricey, either. We also use it because they have a discount for educational institutions, which we are.

it has a visual editor, but I never use it so I can't say how good it really is.

Use a Git server like Bonobo and you can use the various GUI tools (like TortoiseGit, for example). It's not TFS like you want but you are not going to find any clients that interact with TFS other than the VS and Eclipse plug-ins and the command line tool.

SQL is pretty straight forward compared to traditional coding since it is an interpreted language that looks a lot like readable English.

Just try out some learn to code sites and you will get up and running in no time.

http://sqlzoo.net/wiki/Main_Page

click on SELECT basics and have fun. :)

Only the bits you want to replicate. You should browse through this and a Step by Step Guide.

A few options, if you embed the data set in the report, you can just have the report pass multiple values for the parameters. literally it's just as easy as "select * from XTable where value in (@Parameter)". However that's not very efficient, since it won't have the performance profile of a stored procedure.

Next up is a simple and\or statement, select * from Xtable where ((@Parameter = Column) or (@Parameter = 'N' and column = ' '))

There are many other not as good solutions; Creating a view with a case statement to replace the ' ' with an N, and then have you query run against that. This performs OK since the views execution plan is cached, and simplifies code in the procedure the report is calling.

The worst solutions which I wouldn't recommend unless you really really have to be able to take multiple parameters;

Set the report to pass the parameter values as a single comma delimited string, create a function that parses the string and creates a row for each of the values, then use an in statement something along the lines of "where value in (dbo.your_function(@Parameter))". Here is an article that explains it in a little more depth http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/

Last and definitely least, you could set the query up as a string with the parameter values passed in as a comma separated string, then exec the string. http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure , Unless it's absolutely necessary don't do this, in fact your much better off just embedding the data set in your report.

Have you tried updating SSMS to 18.9.2?

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

I still think it's ssms working against the version of SQL and not the other way around.

SSMS is now its own download. Works with any edition of SQL Server. I even use it to manage servers as far back as 2008 with no issues.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

On the SSMS download page it says it's backwards compatible with all supported SQL Server versions. So 2008 and up. It says this about older versions "There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly. " https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

So you'll need to install an older SSMS version.

I have a W11 upgraded from W10 and just installed SQL Server 2019 Dev from here: https://www.microsoft.com/en-us/sql-server/sql-server-downloads?rtc=1 and it worked OK. I noticed that OP installed the RTM version (15.0.2000.5). You might want to try installing the latest version (CU13 as of right now) and see if that helps. Running SQL in a container - either Windows or Linux - is certainly a valid and good option if that works for your development workflow.

No, Dev Edition is permanently free. But the license expressly says that it is to be used in a non-production environment. If you're seeing something like a 180-day limitation, make sure you're getting it from the right source (https://www.microsoft.com/en-us/sql-server/sql-server-downloads).

SQL Server Developer Edition should work for you. Remember to also download Management Studio as well. Best of luck on your next round!

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Depends on what you want to do with it.

If it's for your own use, you can install SQL Server 2019 Developer Edition. It's full-featured and free except in production environments.

For anything else, especially if it will be public-facing, consider Azure, or maybe GoDaddy.

>9 for TRIAL is availa

Yeah I don't get it. Is the full version available or not? I keep getting redirected to the Evaluation Centre from this page when clicking on "Install on Windows".

You should be able to.

I'd start with SQL Server 2016 Management Studio to connect to an instance of SQL Server. (You may need to run this as "Administrator".)

Then use the "Databases" menu to "Attach" a database (the mdf file).

A basic AD to me means an AD set up in a very basic way - i've managed to get it working with some simple configurations. Not sure what a level/features a basic AD means to the professionals in the industry.

And i'm using the term WAMP to mean one of many software packages that include apache, php, and an SQL database. Eg. WAMPserver

If you want a basic desktop application for submitting API calls, download Postman. It is easy and great for one-off commands.

If you want to automate your API calls, try the PowerShell commands that folks have already mentioned.

If you don't want to spend anything you can download SQL Server Express Edition 100% free

http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

If you're looking for an SQL database that's free to use in production too, there is only one choice in my opinion: PostgreSQL.

http://www.postgresql.org/

Hi,

You can try our .NET ADO.NET provider for Salesforce from Devart - https://www.devart.com/dotconnect/salesforce/download.html

Also our company provides SSIS Data Flow Components for Salesforce - https://www.devart.com/ssis/salesforce.html

Both products are commercial and have 30-day trial period

Replying to my own comment here to state that I do have an exception: Microsoft’s monthly Power BI updates sessions are an hour long, and always get me excited about new features for a tool I already paid for (or is free if you’re using it for personal usage). They’ve done these monthly for years and my team and I usually get good tips from these.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/

If you are accessing multiple RDBMS systems, then use a tool that can connect to many different database engines. Personally I think the free tool dBeaver is great.

https://dbeaver.io

https://www.amazon.com/SQL-Antipatterns-Programming-Pragmatic-Programmers/dp/1934356557

I have more than once seen the Entity-Attribute-Value anti-pattern used. Generally it's best to bring this to the attention of your direct and then run screaming to find a new job.

Also I've seen GUIDs used as PKs.

Best book on the Topic written by the crazy talented Pedro Lopez. Feels less like reading stereo instructions than any other SQL book or your money back. Otherwise if you're move of a video person Erik Darling has a great inexpensive(seriously 50-100 bucks) video series for learning this stuff as well. Copy pasted from a previous post but still good stuff all around.

AKA.ms/learn has lots of great resources. Otherwise this book by Pedro Lopes is the best I've seen on the topic. If Video is more of your go to then Erik Darling has great inexpensive video content that's helpful fantastic as well.

Edit: Spelling.

Best book on the Topic written by the crazy talented Pedro Lopez. Feels less like reading stereo instructions than any other SQL book or your money back. Otherwise if you're move of a video person Erik Darling has a great inexpensive(seriously 50-100 bucks) video series for learning this stuff as well.

Tsql fundamental is a tough book to read if you are a noob. You should try this book

https://www.amazon.com/Server-2005-T-SQL-Recipes-Problem-Solution/dp/159059570X/ref=mp_s_a_1_5?dchild=1&keywords=tsql+recipes&qid=1615339607&sr=8-5

It is a bit old but the stuff in there are still valid.

C# is a great tool to have to expand on your SSIS flexibility. I found this book to be a great resource in my SSIS development. It covers a majority of the tasks that SSIS tools can't accomplish natively.
https://www.amazon.com/Extending-SSIS-NET-Scripting-Integration/dp/1484206398/ref=sr_1_1?dchild=1&keywords=.net+for+ssis&qid=1601580178&sr=8-1

I would argue that Access actually has less significance on a resume than excel.

If your interest lies more along lines of reporting then Power BI may be something worth pursuing.

https://smile.amazon.com/SQL-Tuning-Generating-Optimal-Execution/dp/0596005733/

Run an explain plan and see what the high cost operations are. Determine if there are ways to get the same results with more cost-efficient operations.

They sell one handed keyboards. In your case, there's an Intel Remote Keyboard app for phones that works on Windows. That may be the most comfortable. Android version: https://play.google.com/store/apps/details?id=com.intel.remotekeyboard

It says it's for compute sticks but supposedly it works on any Windows PC.

I would get her SQL in 10. That seems to be a great beginner book.

T-SQL Fundamentals would be the next book afterwords I'd think.

I learned a ton from ExcelisFun youtube, that was my go to learning 7-12 years ago. Plural may not be a bad idea though since she has a variety of interests it sounds like.

> Querying T-SQL by Ben-Gan or any of his other books.

So say, this one?

https://www.amazon.com/Inside-Microsoft-Querying-Developer-Reference/dp/0735626030/ref=la_B001IGQENW_1_10?s=books&ie=UTF8&qid=1506320525&sr=1-10

You should be able to accomplish this with T-SQL using Window Functions. Here is a link to an article that gives you the basic approach: sql-linear-regression. Window functions are very powerful for all kinds of statistical analysis. For more examples including rolling averages and period comparisons, check out Expert T-SQL Window Functions in SQL Server.

I like my own book. ;) You find a free excerpt here: http://bi-solutions.gaussling.com/sql_basics_excerpt/

If you want to go directly to amazon: https://www.amazon.com/dp/B0733D7MCR/ref=cm_sw_r_cp_dp_T2_fXmtzb2XB2WRY

We use this book which I think is a great introduction to databases and good on "all-around" knowledge. https://www.amazon.com/Database-Management-Systems-Ramakrishnan/dp/9339213114/ref=mt_paperback?_encoding=UTF8&me=

https://www.amazon.com/Training-70-461-Querying-Microsoft-Server/dp/0735666059

Even if you don't take the test this book is well written and it exposes you to useful things you may not otherwise stumble across - like windowing functions.

the MS 462 book, ick.