Are the posted questions getting worse?
-
My MongoDB training starts today...there goes the neighborhood! :crazy:
Always a good thing to learn new skills but at my age I seem to forget more things than I take in. I'm just imagining my brain having a heck of a time trying to free up space in there and always being at 99% full disk space. lol
SELECT quote FROM brain WHERE original = 1
0 rows returned -
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?Keep writing regular, good material, and stop looking at the stats.
I think the first 6 months or more of mine I barely broke double-digit hits any day. And then there's my personal (non-SQL) blog:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Grant Fritchey (8/2/2016)
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month, minimum, one per week. More is OK, but less isn't. You want people to expect content.I found that once a fortnight was about the most I could sustain, and even that I've failed at recently (had big personal project taking up a lot of evenings)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (8/2/2016)
Grant Fritchey (8/2/2016)
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month, minimum, one per week. More is OK, but less isn't. You want people to expect content.I found that once a fortnight was about the most I could sustain, and even that I've failed at recently (had big personal project taking up a lot of evenings)
Fortnightly is fine too. It just needs to be fairly consistent and regular so that things look active & not dead.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant Fritchey (8/2/2016)
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?Is it quality over quantity? Or should I be aiming for X number of article per month? I would really like to write stuff where I know people are actually reading it.........
Any advice is much appreciated - thanks.
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month, minimum, one per week. More is OK, but less isn't. You want people to expect content. Plus, new content improves your search results.
Other than that, I'm trying to improve my own stats and not much is working.
I tweet when a blog post goes up, and then again 2-3 days later. I also post to facebook, linkedin, pinterest and tumblr automated through If This Then That.
That's about it.
I have to remember to try and tweet a few days after the new post. I never seem to do that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
SQLRNNR (8/2/2016)
Grant Fritchey (8/2/2016)
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?Is it quality over quantity? Or should I be aiming for X number of article per month? I would really like to write stuff where I know people are actually reading it.........
Any advice is much appreciated - thanks.
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month, minimum, one per week. More is OK, but less isn't. You want people to expect content. Plus, new content improves your search results.
Other than that, I'm trying to improve my own stats and not much is working.
I tweet when a blog post goes up, and then again 2-3 days later. I also post to facebook, linkedin, pinterest and tumblr automated through If This Then That.
That's about it.
I have to remember to try and tweet a few days after the new post. I never seem to do that.
Automated. It's all automated. I couldn't remember to do it otherwise.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.
Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
-
jasona.work (8/2/2016)
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
Alas, I've found someone else who has to deal with CF. We'll have to talk at the next SQL PASS meeting.
-
Ed Wagner (8/2/2016)
jasona.work (8/2/2016)
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
Alas, I've found someone else who has to deal with CF. We'll have to talk at the next SQL PASS meeting.
Heh. The extent of my dealings with CF end at the NIC port on my servers. Other than helping out tracking down the connection string changes to get CF to talk to a SQL Server with "Enforce Encryption" enabled...
-
jasona.work (8/2/2016)
Ed Wagner (8/2/2016)
jasona.work (8/2/2016)
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
Alas, I've found someone else who has to deal with CF. We'll have to talk at the next SQL PASS meeting.
Heh. The extent of my dealings with CF end at the NIC port on my servers. Other than helping out tracking down the connection string changes to get CF to talk to a SQL Server with "Enforce Encryption" enabled...
If you have the part figured out to let CF talk to SQL Server with "Force Encryption" set on the connection, we REALLY have to talk at the next meeting. 😀
-
Ed Wagner (8/2/2016)
jasona.work (8/2/2016)
Ed Wagner (8/2/2016)
jasona.work (8/2/2016)
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
Alas, I've found someone else who has to deal with CF. We'll have to talk at the next SQL PASS meeting.
Heh. The extent of my dealings with CF end at the NIC port on my servers. Other than helping out tracking down the connection string changes to get CF to talk to a SQL Server with "Enforce Encryption" enabled...
If you have the part figured out to let CF talk to SQL Server with "Force Encryption" set on the connection, we REALLY have to talk at the next meeting. 😀
I'll have to get it from the guy who manages the ColdFusion web servers, my e-mail with it seems to have gone with my last laptop upgrade...
Which bites...
-
Even better, it's just a matter of hunting around because you tend not to delete anything!
The Adobe forums topic where we found out how to get it to work:
https://forums.adobe.com/thread/1655440
At the time, we were running CF10 and the "EncryptionMethod=SSL ValidateServerCertificate=false" in the connection string worked (and bear in mind, we're using a certificate from a trusted cert authority, not a self-signed)
-
Ed Wagner (8/2/2016)
jasona.work (8/2/2016)
Got to sort out a problem query this morning with one of the developers. Was rather interesting, initially tossed a couple indexes on a table (clustered index on the rowid field, which was an int identity(1,1), and yes the table was a heap at the start), followed by a non-clustered on the two columns in one of the joins in the query.Then, the query (as I had it) was finishing quick, but when the dev ran it, it still took 3-4 minutes...
The difference being, I had taken the variable and set it to the search value, while he was just plugging the search value in directly.
He tried setting the variable, but was getting errors it had already been declared...
Well, come to find out ColdFusion implicitly declares variables (and with such descriptive names of @P1, @P2, etc) Once he set up the query to declare a new variable with a new name and set it equal to what ColdFusion was setting, the query ran like gangbusters...
Now if we could only train the user that started the whole thing to be a touch patient if something's taking a bit longer to return, rather than mashing F5 to refresh the CF page (and putting dozens of queries for the same thing into SQL.) Let the poor guy know first, THEN mash F5...
Alas, I've found someone else who has to deal with CF. We'll have to talk at the next SQL PASS meeting.
Well, add another to that list. CF is a pain, especially when the developers embed the SQL code in the CF code, and build it dynamically to boot.
Also, watch the settings. We got inexplicable deadlocks between unrelated tables when all string values were sent to SQL Server as NVARCHAR when some of them should have been VARCHAR.
-
GilaMonster (8/2/2016)
BLOB_EATER (8/2/2016)
Do you guys have any advice on how to improve my stats for my blog?Keep writing regular, good material, and stop looking at the stats.
I think the first 6 months or more of mine I barely broke double-digit hits any day. And then there's my personal (non-SQL) blog:
GilaMonster (8/2/2016)
Grant Fritchey (8/2/2016)
Publish as regularly as possible. It doesn't have to be on a set schedule, but it needs to be fairly consistent. I go for 4 a month, minimum, one per week. More is OK, but less isn't. You want people to expect content.I found that once a fortnight was about the most I could sustain, and even that I've failed at recently (had big personal project taking up a lot of evenings)
Both - thanks for the advice. I will adhere to all said. I will find that balance between writing and working on Paul's Waits & Latch library. cheers
-
jasona.work (8/2/2016)
Even better, it's just a matter of hunting around because you tend not to delete anything!The Adobe forums topic where we found out how to get it to work:
https://forums.adobe.com/thread/1655440
At the time, we were running CF10 and the "EncryptionMethod=SSL ValidateServerCertificate=false" in the connection string worked (and bear in mind, we're using a certificate from a trusted cert authority, not a self-signed)
Thank you, Jason. I've sent it off to our CF admin. He wasn't able to make it work late last year with a new SQL Server I brought online. I know we were running an old version of CF at the time and are almost ready to bring CF 11 online and migrate things to it. I guess looking on CF sites for CF solutions isn't good enough; I'll have to tell him to start looking on SQL Server sites. 😛 Again, a huge thanks for this.
Viewing 15 posts - 55,171 through 55,185 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply