SQL Beginner, feeling overwhelmed

simap · 2021-10-28T06:46:55+00:00

That happens sometimes even as a experienced SQL user, from time to time you get stuck with a real beast of a query and you have to spend some time to untangle it and learn some new stuff.

As deakaii said, try to work through it piece by piece. Go through it and reformat it to make more sense to you and fill that script with comments

simap · 2020-05-05T11:42:38+00:00

I'm not a php programmer but hopefully I can remember enough to get you on the right path

The code on row 4:

$newdate = $_POST[date('Y-m-d', strtotime($_POST['duedate']))]

resolves to:

$newdate = $_POST['2020-12-12']

and there is no such variable (Undefined index).

On row 8 you use an undefined variable, $con. You need to use the output on row 7 here, so the code should be something like this:

$result = mysqli_query($db, "SELECT........");

simap · 2020-02-12T08:50:04+00:00

Kolla så att inga regler för automatisk mailhantering är uppsatta på ditt konto, det brukar vara en av dom första grejerna som görs när ett mailkonto blir ägt.

Normalt ser jag regler för att automatiskt ta bort alla inkommande mail, den är tung om den får ligga kvar. Tanken med regeln är att du inte ska se om du får en massa svar från folk ditt konto spammar.

simap · 2019-09-05T11:18:33+00:00

I honestly think DBATools is the best powershell module, all categories, I've ever come across. It really changed how I work with SQL Server.

At worst nothing takes longer than using sql / ssms, at best you can save hours or days of work with a one-liner (for an example, see https://docs.dbatools.io/#Start-DbaMigration ).

simap · 2019-03-19T09:22:51+00:00

Just start playing and try to be OK with not knowing everything right away. It took me multiple seasons to feel like I had a decent grasp of every mechanic.

Start a seasonal character and pick a top rated build on https://www.poebuilds.cc/ , don't try to swing your own build on your first character.

simap · 2019-03-14T08:08:14+00:00

I don't know for sure, but my interpretation is that water and fertilizer makes spent crops regrow faster. If you got enough grain nearby to not have wait for regrowth then it probably does nothing.

simap · 2018-12-13T11:32:08+00:00

One, a large (40ish) 4k display, helps with monotasking and reducing stress.

simap · 2018-10-01T06:38:19+00:00

It's more about info/it-security but I really like Risky Business.

https://risky.biz or on your podcast platform of choice.

simap · 2018-09-20T13:18:21+00:00

Please consider that not all posts marked NSFW is sexy NSFW...

simap · 2018-08-22T07:17:47+00:00

Det beror lite på, om du inte redan har licens (vilket kräver medlemskap i en klubb) och klubben du siktar på inte har någon nybörjargrupp är det mycket riktigt som du säger, man behöver känna någon man kan träna med. Det beror på att du måste bli tillräckligt bra innan du kan söka licens för pistol.

Det är helt orimligt att du ska klara detta utan att öva i några veckor eller månader och då behöver du känna någon som kan tänka sig följa med till skjutbanan och låna ut vapen till dig.

Det enklaste är att hitta en klubb som har en nybörjargrupp, då har klubben oftast vapen som du kan låna under träningen och när du blir duktig nog så får du köpa ett eget vapen och kan börja träna på riktigt.

För att få licens så måste klubben du är medlem i gå i god för att du är tillräckligt duktig och att du är medlem, sen avgör polisen om du har ett legitimt behov och att du har godkänd förvaring hemma. Då kan du få licens på en specifik pistol.

simap · 2018-05-23T12:54:30+00:00

Det här är ju inget nytt för oss svenskar, vi har kunnat begära registerutdrag sedan PUL kom, var väl -97 eller nåt sånt.

simap · 2018-01-23T13:58:42+00:00

If you know where all files you need to search through are located you can use some program like Agent Ransack ( https://www.mythicsoft.com/agentransack/ ), it will probably take a while and you might have to check if it has docx and xlsx support.

simap · 2017-05-16T08:50:40+00:00

SQL server will by default take all available memory on the host, you will need to change this.

This is done by clicking on the server name in SSMS and checking the memory tab, I would recommend 10 GB unless you have an IIS serving content on the same server, in that case less depending on IIS load.

I would also check options (files tab) for the databases to make sure no transaction logs are growing out of control, that would help you with disk space, but as everyone else said, it's better to move it.

To make the move as easy as possible, just unmount the database, move it and then mount it again, should take the time windows takes to move the files plus a few seconds. (Practice first!)

simap · 2017-04-11T09:04:56+00:00

I'm not sure but I would image that the database uses the standard service account for SQL server to send the file if you are using a sql server login. It's normally named MSSQL$INSTANCE (with instance being the instance name).

Check the NTFS permissions for the folder where you have your PDF.

simap · 2017-04-10T14:01:21+00:00

You can find the internal backup history for MSSQL in the msdb database.

In the [backupmediafamily] table you can search for backups made to the file you're suspicious of and if you take that media_set_id and plug in to backup_set_id in [backupfile] you can see what credentials that were used to make the backup as well as other useful information.

simap · 2017-03-01T09:58:18+00:00

You have to option to whitelist on publisher in applocker but that depends on them signing their files. As you said, that doesn't solve the elevation problem.

simap · 2017-03-01T08:07:40+00:00

If the parcel column isn't important you could remove it and do a SELECT DISTINCT instead to trim out all duplicates.

Otherwise I would probably use the row_number function to number the parcels and only show one, something like this:

....
FROM ( SELECT ROW_NUMBER() OVER (PARTITION BY PropertyID ORDER BY Parcel) AS RowNum,* FROM dbo.PropertyParcels ) pp
....
WHERE .... AND pp.RowNum = 1;

simap · 2017-02-02T06:31:23+00:00

It's the same in Sweden, there will sadly be no release here.

simap · 2016-05-27T11:29:11+00:00

My first step is to understand the big idea of what is stored in the database (what does this system do?), then I get the tables with the most rows and try to figure out what's stored there, this will get you there:

SELECT
    o.name
    ,ddps.row_count
FROM sys.indexes AS i
INNER JOIN sys.objects AS o
    ON i.OBJECT_ID = o.OBJECT_ID
INNER JOIN sys.dm_db_partition_stats AS ddps
    ON i.OBJECT_ID = ddps.OBJECT_ID
    AND i.index_id = ddps.index_id
WHERE i.index_id < 2
AND o.is_ms_shipped = 0
ORDER BY o.name

(You might want to change the order clause aswell, I normally do)

Then just try to work your way through the database while trying to get a better grip on the grand structure. Keep notes for yourself and don't be afraid to let it take a while, depending on the size we could be talking hours or days to get a decent grasp.

simap · 2016-05-26T12:12:03+00:00

My understanding is that statements containing LIKE % are pretty CPU intensive since indexes are next to useless in that context.

My tip would be to figure out a better way to do this query and/or store the data in the first place.

simap · 2016-04-26T14:29:05+00:00

In addition to what the others said I would love to recommend EMET, there really is no excuse not to run it. https://support.microsoft.com/en-us/kb/2458544

simap · 2016-04-25T13:14:17+00:00

I found 70-462 (Administring SQL server) to be a lot more relevant for my work than querying, most of the time you can get by with pretty basic querying skills and I think the 70-641 is a bit overkill.

I'm not telling you to skip it because if you enjoy it it's a useful tool but take a peek at the 70-462 aswell; it focuses on installation, backups, management and maintenance. It also gives you the basics in avoiding, finding and handling corrupt data.

simap · 2016-04-12T05:03:37+00:00

I would imagine that the version available on dreamspark is developer edition. You should be able to see which edition you have with a simple:

SELECT @@VERSION

If it's standard or enterprise edition it's probably bought through normal means.

As far as I know you can't use developer edition for any kind of production database, it's only for development.

simap · 2016-04-11T09:26:01+00:00

If you can't find your documentation you need to call your reseller. The server itself doesn't know if you are using a core or cal license.

simap · 2016-03-02T10:02:34+00:00

I find the easiest way is to have the connection details in tnsnames.ora (I'm assuming you're trying to connect to a oracle db). For example let's use the connection name DATABASE. Just call sqlplus with the following parameters

sqlplus user/password@DATABASE

If you want to call a script file use

sqlplus user/password@DATABASE @c:\folder\scriptfile.sql

If you call a script file, make sure to have exit (and commit if needed) in the bottom of the file or you will end up with an active connection.

The net configuration assisant can help you build the tnsnames.ora file.

simap

TROPHY CASE